Purchase Solution

Query on data dictionary views (classmate schema) in oracle

Not what you're looking for?

Ask Custom Question

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 and low values found in each column (the values are in hexadecimal format). When you are logged on as CLASSMATE, run the query. The query should only report on the CLASSMATE schema. Save the query in a file.

Purchase this Solution

Solution Summary

This provides a detailed step by step queries to find out the number of tables using the tables: DBA_TABLES
and also using the columns information using: DBA_TAB_COL_STATISTICS

This provides a solution that can be used any tables(views)

Solution Preview

SELECT TABLE_NAME, NUM_ROWS, AVG_ROW_LEN
FROM DBA_TABLES

nOTE: If you want see only for on table add this condition
for above query WHERE TABLE_NAME ...

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C++ Operators

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

Excel Introductory Quiz

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

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Javscript Basics

Quiz on basics of javascript programming language.