Re: SQL*Plus / Report Script for Table Information

Jim Morris (morri055_at_gold.tc.umn.edu) wrote:
: I am documenting a number of queries that I have written using SQL*Plus. My
: problem is that the DESC command is lacking. I am looking for a script which
: can create robust, table definition reports that can be included in my
: documentation with no additional editing. The basic information to be
: included must be:
:
: Table Name
: Column Name
: Primary Key
: Null?
: Data Type
: Index Column
: Column Size

    First of all, would you mind to specify the output format you want to have ?

    Then, do you mean that you wanna write the script without using the DESC command ?

    Should you have any enquiries, please feel free to email to me.

--
                                                               Best Regards,
                                                                 Lun Wing San


Email address : sunny_at_hkpc.org / wslun_at_cs.cuhk.hk                           
Telephone     : (852)2758 5936 / (852)2788 5841