In this Hands-On, you will view some of the Oracle directory views and experience the Oracle object dependencies (timestamp).

     1- Directory Views

     2- Security

     3- Tracking Dependency

Go to “MS-DOS.”

Login to “sqlplus” as "iself/schooling.”

=

Use the "column" command to change the output format length of the Object name to 30 characters.

Query all the object names, their type and status from user_objects where their object names start with ‘D-E-P-T.’

Describe the dept table.

Then change the “l-o-c” column size from 13 to 14 characters.

Describe the dept table again.

Notice that the location column size was changed.

Query all the object names, their type and status from user_objects where their object names start with ‘D-E-P-T.’

Notice that the dept_name function became invalid.  Because the dept_name function was dependent on the dept table.

Compile the dept_name function.

Then query the object names, their type and status from user_objects where their object names start with ‘D-E-P-T.’

Now, both are valid.

That was an example of object dependencies.

Now, you should practice this over and over, until you become a master at it.

Good luck!