Database Stuff

Repository of Database Related Information, Assets and Knowledge Base covering Oracle, SQLs, Scripts, Performance Tuning etc

SQL Stuff

w3schools SQL Tutorial:
http://www.w3schools.com/sql/default.asp

SQL (orafaq):
http://www.orafaq.com/wiki/SQL

Oracle SQL FAQ:
http://www.orafaq.com/wiki/SQL_FAQ
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: oracle SQL, SQL, SQL Faq, SQL Tutorial

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

oracle SQL oracle database oracle 10g SQL Optimizer user v$session parameter sid sqlplus;database name userid username SET SPOOL SQL Faq SQL Tutorial column imp import initialization optimization oracle DBA oracle hints process rename rename table sizing sql hints statistics status system tables table table locks tablespace temp tablespace user name v$lock v$parameter v$process v$sessmetric v$sql

Blog Archive

  • ►  2012 (3)
    • ►  September (3)
  • ►  2010 (3)
    • ►  September (1)
    • ►  May (2)
  • ►  2009 (11)
    • ►  October (2)
    • ►  September (9)
  • ▼  2008 (2)
    • ▼  December (2)
      • SQL Stuff
      • Oracle Database Stuff

Popular Posts

  • Oracle: Monitoring progress of import jobs
    Code to monitor speed of import jobs: select    substr(sql_text,instr(sql_text,'INTO "'),30) table_name,    rows_processed...
  • Oracle: Script to check for table locks
    Script to check for Oracle table locks: Display details on which table is being locked by which process/user select s1.username || '...
  • Oracle: SqlPlus Useful Set Command
    Useful SET commands for output formatting and SPOOL: SET TERM OFF -- TERM = ON will display on terminal screen (OFF = show in LOG o...
  • Oracle: SQLplus Prompt to show user, connection (10g)
    SQLplus Prompt to show user, connection (Oracle 10g) run the following in sqlplus: set sqlprompt "_USER'@'_CONNECT_IDENTIFI...
  • Oracle: Script to display current slow job details
    Oracle Script to display slow jobs details column e_dttm format a15 column usr format a10 column hp format 9999999999 select TO_CHAR(...
  • Oracle: Get database name using sqlplus
    Get database name using this sql: select ora_database_name from dual;
  • Oracle Hints (10G)
    Hints for Optimization Approaches and Goals ALL_ROWS The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a statement...
  • Oracle: Script to display session details
    Script to display Oracle session details: column value format a40 column description format a100 SELECT 'AUDITED_CURSORID' AS P...
  • Oracle: Check which user is holding temp tablespace
    Check which user holding temp tablespace SELECT s.username, s.sid,  u.TABLESPACE, u.CONTENTS, u.extents, u.blocks   FROM v$session s, v$s...
  • Oracle: List freespace by Tablespaces
    Use the following script to get sizing (free,used etc) for tablespaces: -----------------------------------------------------------------...

Pages

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments
Awesome Inc. theme. Powered by Blogger.