recent

Titulo

Oracle Data Dictionary


Oracle view supports three types of user type, ALL, USER, & DBA. This helps you dig the detail around Oracle database objects.
 See example
  • ALL_ lists everything under your schema  plus the objects of other’s schema which you have access to.
  • DBA_ lists everything from the Database. ( DBA only)
  • USER_ lists everything from your schema.(Developer & DB users)
Some of my frequently used system views
  •         ALL_CONS_COLUMNS — all columns                  
  •         ALL_CONSTRAINTS  — all constraints              
  •         ALL_IND_COLUMNS  — index columns                
  •         ALL_INDEXES      — all indexes                  
  •         ALL_OBJECTS      — all objects                  
  •         ALL_TAB_COLUMNS  — all table column            
  •         ALL_TAB_COMMENTS — all table column            
  •         ALL_TABLES       — all tables                  
  •         ALL_TRIGGERS     — all triggers                
  •         ALL_VIEWS        — all views                    
  •         DBA_CATALOG      — catalog                      
  •         DICT_COLUMNS     — dictionary table with columns
  •         DICTIONARY       — all the dictionary          
  •         DUAL             — dummy table
Interested in working with me? I can be reached at pbaniya04[at]gmail.com for any questions, consulting opportunities or you may drop a line to say HELLO. Thank your again for visiting my blog and looking forward to serving you more.

Have a Database-ious Day!

No comments

Powered by Blogger.