Oracle9i - 2. Write a query, based on data dictionary views, reporting a table’s name, number of rows, average row length, column name (in order they appear in the table), the average column length, and the high ...
Oracle9i Database - 2. Create SQL script that completes the following task successfully.
1. Create a locally-managed tablespace named HANDS_62 with one 10 M OMF datafile in the directory name of your choice.
2. Add an ...
Oracle 9i Database Management - 1. What are the ways in which an Oracle database can be created?
2. Discuss sequences.
3. Under what conditions should indexes be used?
4. Explain the three levels of transaction ...