Purchase Solution

Oracle9i

Not what you're looking for?

Ask Custom Question

1. You want to make a report of table attributes. This report consists of a series of queries on data dictionary views in which you specify the table name, and the queries return details about the table. Your goal is to have information on the report that is similar (in content, not format) to the informaiton you see when you look at the Schema Manager's table property sheet in the console. Include as much informaiton as you can match the information you see for the CLASSMATE.WANT_AD table when looking at the General tab of the property shee (table_name, column names, data types, and so on). Review the data dictionary views and select the views you think would produce the best results. Then write a series of queires that display the columns you want displayed on the report. Use COLUMN commands to adjust the headings and column width so the report is more readable. Make sure the columns are listed in the same order as they appear on the property sheet. Write the queries to report the details of the WANT_AD table of the CLASSMATE schema. Save teh script in a file.

Please see table.html file for further information...

Purchase this Solution

Solution Summary

Oracle9i is examined.

Solution Preview

Note: I was missing some of display values.Please check that.

dbms_output.put_line("General")

dbms_output.put_line("Columns:");

SELECT COLUMN_NAME AS "Name" ,DATA_TYPE as "Data Type" ,DATA_LENGTH as "Size",
DATA_SCALE as "Scale",NULLABLE as "Nulls?" ,DEFAULT_VALUE as "Default Value"
FROM DBA_TAB_COL_STATISTICS
WHERE TABLE_NAME = 'WANT_AD'

dbms_output.put_line("Constraints:");

select Constraint_name as "Name",Constraint_type as "Type"
,Status as "Disable?"
,R_Owner as "Referenced Schema"
,R_Constaint_name as "Referenced Table"
,delete_rule as "Cascade On Delete"
,search_condition as "Check Condition"
,deferrable as ...

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.