Write a script that provides all of the information in and d

Write a script that provides all of the information in, and duplicates the formatting of, Oracle\'s SQL*Plus describe command. Additionally, the output should add the comments on the rows. Input: owner and table name. Output: columns for Name, Null?, Type, Comments.

Solution

Answer:

Query 1:

SELECT table_name
FROM all_tables
WHERE owner = UPPER(\'&schemaowner\')
AND table_name LIKE UPPER(\'%&table%\');

Query 2:

SELECT table_name
FROM all_tables
WHERE owner = UPPER(\'system\')
AND table_name LIKE UPPER(\'%term%\');