USING SQL DEVELOPER Write an SQL query to extract the following information from

Question

USING SQL DEVELOPER

Write an SQL query to extract the following information from data dictionary:

1.Find all dictionary views that contain information about indexes.

2.How many indexes are defined on OE.CUSTOMERS table? (Hint: all views have meaningful name, just search the page)

3.For each index you found in #3 how many distinct keys?

4.Use V$...stat views to find information about "free memory" and "DB time"

Hint: DB time is system parameter
free memory is SGA (System Global Area) parameter

5.From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples.

Worksheet Query Builder select. from ctionary x Explain Plan X Query Result x Script Output t SQL All Rows Fetched: 3124 in 0,999 seconds E TABLE NAME COMMENTS i DBA CONS: COLUMNS Information about accessible columns in constraint definition 2 DBA LOG GROUP COLUMNS Information about columns in log group definitions 3 DBA LOBS Description of LOBs contained in all tables 4 DBA CATALOG All database Tables, Views, Synonyms, Sequences 5 DBA CLUSTERS Description of all clusters in the database

Explanation / Answer

1.select view_name from all_views

2.select count(views) from all_views

3.SELECT DISTINCT column_name FROM table_name WHERE column_name IS NOT NULL;

4.select DB time from v$database;

5.Procedure is the best one views show the data into window format and convertions after procuderes for easy data storage

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.