Explore BrainMass
Share

Explore BrainMass

    Oracle9i

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

    © BrainMass Inc. brainmass.com October 9, 2019, 6:36 pm ad1c9bdddf
    https://brainmass.com/computer-science/data-clustering/oracle9i-92457

    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