Hi. I am trying to describe a table and include the command on output.
(ie. DESC ECR.TABLE1 I would like to include the command on the output so I can have the tablename on the output..
What setting do I need to turn on ? I tried various sqlplus settings, but nothing seems to do what I want. Please help thanks.
Hi. Your example works for 1 table.
I have created a 'tables.sql' script which has 150 desc statements(the entire schema). The output displays the structure of all the tables and does not include the table name. I have not found a way to do this ? Anybody know how ?