Every Oracle database uses a number of system tables and views to keep track of database objects in the database. This collection of system objects (tables and views) is called data dictionary or system catalog. Data dictionary is an effective tool to find out about information on database objects in the database.

This week's discussion focus on applications of data dictionary.

 

1. If you want to know which tables exist in PRACTICE07 schema after you complete the study of chapter 7, which data dictionary view will be the best to query?
2. Provide a SQL query to find out the names of existing tables?
3. What is the difference between DBA_TABLES, ALL_TABLES and USER_TABLES?
4. What is the difference between USER_TABLES and USER_OBJECTS?

Please make sure to answer each of the question.

When you are ready, please click Discussion Board to login.

Class Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University