ORACLE

Rasim ŞEN - Arka Bahçem : )), özgür ansiklopedi

• TEMPORARY TABLOLAR
• TRANSACTION CONTROL
• SQL TUNNING
• TOAD
• Oracle SQL Functions
• Oracle Partitioning - Kaynak
• Date & Time - Tarih saat formatlama, fonksiyonlar..
• Generating Some Random Data

Fields
-----------
SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='TABLE_NAME_TO_DESCRIBE';

comments
-----------
SELECT comments
FROM user_col_comments
WHERE table_name='MY_TABLE';

Oracle Connect By Function
----------------------------
[[http://www.psoug.org/reference/connectby.html|Connect By Prior]]

 select 1,level, BALANCE_NAME, null, null 
 from CUR_BALANCE_GROUP            
  start with BALANCE_PARENT=''0''
  connect by prior BALANCE_CHILD = BALANCE_PARENT 
 ORDER SIBLINGS BY balance_order