Develop your facility with a data dictionary

Assignment Help Basic Computer Science

Reference no: EM131336289

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).

Reference no: EM131336289

Questions Cloud

Compute the diluted value per share : Mr. and Mrs. Anderson own four shares of Magic Tricks Corporation's common stock. The market value of the stock is $80. The Andersons also have $65 in cash. They have just received word of a rights offering. What is the value of a right? What is the ..

Determine the type of response for each identified risk : Determine the type of response for each identified risk (avoid, transfer, mitigate, or accept). Thoroughly describe what the specific response will be, including any additional tasks to the project plan or a contingency budget where appropriate

Compute the companys predetermined overhead application rate : Calculate the company's predetermined overhead application rate. Calculate the additions to the work-in-process inventory account for the direct material used, direct labor, and manufacturing overhead.

Accounting information systems : An accounting company has three main divisions: tax, auditing, and accounting information systems. Employees in all divisions are hard-working but quiet. They always give thoughtful answers whenever they are asked a question, and usually provide a..

Develop your facility with a data dictionary : 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..

Estimated monthly variable costs using high-low method : Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel customers pay $150 per night. Data for the past 7 months are as follows: January February March April May June July Number of rooms cleaned 25..

Write a full description of the contingency plan : The equipment that you ordered for this project is now a month late. Identify the risk response that is the most appropriate for this risk (avoid, transfer, mitigate, or accept), and write a full description of the contingency plan to go along with t..

Evaluate biocon india group resources and capabilities : Evaluate Biocon india group resources and capabilities by utilizing the value chain framework. how is the company creating value?

Describe the situation and the organization : Select a current news item pertaining to an ethical situation in the Middle East that has arisen in a business or non-profit organization. Describe the situation and the organization.

User Account

All Pages