How many rows are in the


This assignment uses the CH08SURGERY table. Write one or more queries on the data dictionary view(s) to answer these

questions:

1. How many rows are in the table?

2.  What is the average length of a row in the table?

3.  How many columns have no values in any rows?

4.  What is the average length of the DOCTOR_NAME column?

5.  How many distinct values are there in the PATIENT_FIRST_NAME and PATIENT_LAST_NAME columns?

6.  What is the segment name and extent ID of the table's segment and extent?

Attachment:- create_table.zip

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: How many rows are in the
Reference No:- TGS01241800

Now Priced at $15 (50% Discount)

Recommended (98%)

Rated (4.3/5)