Reference no: EM13186658
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.
|
What is the machine precision eps
: Determine (exactly!) the relative error E of x* as an approximation to x? and calculate the ratio l~l/eps.
|
|
Depict a formula for the lowest molecular weight compound
: Draw a formula for the lowest molecular weight compound that contains C, H, and possibly O, N or S, is a chiral compound, contains ONLY one functional group, and is a sulfide.
|
|
Build your own maze
: Build your own maze and make it so easy so i can understand it. try to use for while statement. it is an easy task so please do not make it complicated and follow the instructions that im going to post. another thing do not use the maze that in th..
|
|
Compute p and v and t for initial and final states
: Calculate P,V and T for initial and final states of each process and produce a plot of the two processes on a P,V diagram. Without resorting to equations, explain why the result for part (b) is greater than or less than the result for part (a).
|
|
Develop basic tools to expedite use of oracles 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..
|
|
What type of sampling technique is being used
: A marketing expert for MTV is planning a survey in which 500 people will be randomly selected from each age group of 10-19, 20-29, and so on. What type of sampling technique is being used?
|
|
Count rumford observed that using cannon-boring machinery
: Count Rumford observed that using cannon-boring machinery, a single horse could heat 11.6 kg of water (T = 273 K) to T = 355 K in 2.5 hours
|
|
Find the amount of work in joules required to empty
: Find the amount of work in joules required to empty the trough by pumping the water over the top. (Note: Use as the acceleration due to gravity.)
|
|
Compute the height if the temperature of the waterfall
: Suppose Joule encountered the waterfall at Niagara Falls. Calculate the height if the temperature difference between the top and bottom of the waterfall is 0.20° F.
|