Develop basic tools to expedite use of oracles data

Assignment Help Database Management System

Reference no: EM13379977

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

Goals:

Develop and demonstrate SQL skills

Develop your facility with a data dictionary

Tasks:

1) 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).
Criteria:

1) Well-written code

2) Code meets requirements

Instructions: Enter or paste your written work and/or click "Attachments" to upload your files.

Reference no: EM13379977

Questions Cloud

Introductionwe live in a digital age music video phone : introductionwe live in a digital age. music video phone calls information creation and information consumption are all

Some previous students have declared in their posts that : some previous students have declared in their posts that large companies such as xerox at amp t amp bbc are strongly

1 a what are the agents of evolutionbwhich of these agents : 1 a what are the agents of evolution?bwhich of these agents can introduce new variations to the population?c what are

Please do it as simple as you can build your own maze and : please do it as simple as you can. build your own maze and make it so easy so i can understand it. try to use for while

Develop basic tools to expedite use of oracles data : develop basic tools to expedite use of oracles data dictionarygoalsdevelop and demonstrate sql skillsdevelop your

Design the layout of users domains trusted domains : design the layout of users domains trusted domains anonymous users etc for a start-up open source software company abc.

1 define ethics for the information age cite your sources : 1. define ethics for the information age cite your sources. you may use any original works but may not discuss your

Question 1one of the criticisms of measurement of the work : question 1one of the criticisms of measurement of the work of software engineers is that they will probably change how

In her paper developing an effective metrics program : in her paper developing an effective metrics program rosenberg described a group of sample goals questions and metrics.

User Account

All Pages