M$3$b Develop Tools to Make Use of Oracle's

Data Dictionary

Assignment

Develop basic tools to expedite use of Oracle's data dictionary

Learning Objectives

Develop and demonstrate SQL and database administration skills

Develop your facility with a data dictionary

Tasks

Write a script that provides all of the information in$,$ and duplicates the formatting of$,$ Oracle's

SQL$*$Plus describe command. Additionally, the output should add the comments on the rows.

Input: owner and table name. Output: columns for Name, Null?, Type, Comments.

Format

Submit the code to query the data dictionary. You must submit the code as scripts that the instructor

can run from an SQL prompt on an Oracle DBMS$.$ Your submission must include a description of the

scripts, their actions, and the order in which they should be run. Your code must not have any "side

effects" $($that is$,$ it must not do anything not listed in the assignment description, and all of its actions

must be described in the program header$).$

Grading Criteria

Well$-$written code

Code meets requirements

Query the data dictionary to list the tables that are in your schema.

SELECT table$\_$name

FROM user$\_$tables

TABLE$\_$NAMETABLE NAME

STUDENT

THESIS

FACULTY

THESIS$\_$COMMITTEE

Identify the data dictionary views that provide comments on the data.

COLUMN comments FORMAT A$40$

SELECT table$\_$name, comments

FROM dictionary

WHERE table$\_$name LIKE UPPER$(\text{'}\%$&table$\%\text{'})$;

COLUMN comments CLEAR