Explore BrainMass
Share

Oracle9i

This content was STOLEN 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 16, 2018, 6:42 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
Similar Posting

Oracle9i Database

9. Look at the following CREATE DATABASE command, and find the errors. Then please correct the problem.

CREATE DATABASE ultradb FOR UPDATE OF paralleldb
MAXINSTANCES 25
DATAFILE TABLESPACE 'ORACLE_BASEoradatasystem01.dbf'
CHARACTER_SET US7ASCII
LOGFILE GROUP A ('D:oraclelogsredoA.log') SIZE 50M,
GROUP B ('D:oraclelogsredoA.log') SIZE 50M;

View Full Posting Details