Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

M3b Develop Tools to Make Use of Oracle's Data Dictionary BAssignment Assignment Develop basic tools to expedite use of Oracle's data dictionary Tasks C

image

M3b Develop Tools to Make Use of Oracle's Data Dictionary BAssignment Assignment Develop basic tools to expedite use of Oracle's data dictionary Tasks C 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). Grading Criteria 1 Well-writton codo

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance services an integrated approach

Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley

14th Edition

133081605, 132575957, 9780133081602, 978-0132575959

More Books

Students also viewed these Programming questions