External links
- PL / SQL error handling
- Analytic functions ( over (partition by xx) )
- Analytic functions (First_value, last_value, dense rank)
This Blog posts on Oracle
- Oracle – Shrink LOB columns
- Oracle Schema export using Datapump API
- Oracle Redaction details in the database
- Oracle index in UNUSABLE state
- Oracle object locked by a session (v$locked_object, dba_hist_active_sess_history)
- Oracle tablespace – add space / resize / check autoextend / set autoextend off
- Oracle SGA – System Global Area
Oracle Books
Oracle data dictionary tables (user_ / all_ / dba_)
Objects / tables / columns
user_objects user_tables user_tab_statistics user_tab_columns user_tab_col_statistics
DBA tables
dba_recycle_bin
Redaction
PUBLIC.redaction_columns PUBLIC.redaction_policies SYS.redaction_columns SYS.redaction policies
Use this code 