Re: Selecting all the columns

[Anne-Marie Matula <amatula@OIT.UMASS.EDU>]

Why do you ask?  To expedite coding?  What I do for big tables which I need
to populate or extract data from is get the structure from our database
query tool (for us that is SQL Plus).
Eg:
Descr sysad.PS_PERSONAL_DATA

I then cut and paste the fields into my SQR.
Easy :)

HTH
Anne-Marie

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
161 Whitmore Administration Building
Amherst Massachusetts, 01003-8165
Phone: 413/577-0685
Fax: 413/545-2150



> Date:    Fri, 4 Aug 2000 20:41:38 +0530
> From:    Siva Prasad Juluri <JSIVA@BANGALORE.IMRGLOBAL.COM>
> Subject: Selecting all the columns
>
> Hi ,
> Can anybody help me in selecting all the columns from the table
> without explicitly listing them.
>
> If so how can i populate to the sqr variables.
>
> Thanx in advance