Oracle SQL Tutorial -10 Data Dictionary

Hi ,

In this article I will tell you how to use data dictionary views , what is a data dictionary .

DATA DICTIONARY

• Database information is information about all objects , user privileges , and locations where the information is stored . They can be obtained from tables or views .

HOW TO USE DATA DICTIONARY VIEWS ?

• All view names we want to search are under DICTIONARY .

• It has only 2 columns named Table_name and comments .

SELECT * FROM DICTIONARY;

DATA DICTIONARY VIEWS

USER_OBJECTS

It gives us information about all objects owned by the user .

1. Date the object was created ,

2. Date of last modification ,

3. Object type ,

4. The validity of the object .

SELECT * FROM USER_OBJECTS;

ALL_OBJECTS

Gives information about the objects that the user owns and can also access .

SELECT * FROM ALL_OBJECTS;

1. Tables created by users can be queried ,

SELECT * FROM USER_TABLES;

2. Columns of tables can be queried ,

SELECT * FROM USER_TAB_COLUMNS;

3. Constraints created by users can be queried ,

SELECT * FROM USER_CONTRAINTS;

4. Provides brief information about Constraintler .

SELECT * FROM USER_SEQUENCES;

SELECT * FROM USER_VIEWS;

See you in my next post.