Share
Explore BrainMass

Oracle9i

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

Attachments

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

Solution Summary

Oracle9i is examined.

$2.19