--
-- CS 325 - some demos from the 
--          Week 3 Asynchronous material
--
-- last modified: 2021-09-07

-- Oracle, like many relational DBMSs, provides some metadata
--    in the form of tables!
--
-- for example: a user_tables table, and a users_objects table

describe user_tables

describe user_objects

-- another form of the SQL select statement lets you specify
--     just what columns you want to see from a table;
-- for example, here's how I can see JUST the table_name
--     column from the user_tables metadate table:

select table_name
from   user_tables;

-- and here's how I can see just the object_name and object_type
--     columns from the user_objects metadata table:

select object_name, object_type
from   user_objects;