Re: Select ALL

[Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>]

You can dynamically build your select. Use the column system table of
Oracle.
----- Original Message -----
From: "Brickl, Maria" <mbrickl@UWC.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, March 27, 2002 12:33 PM
Subject: Select ALL


> Is there any way in SQR to select all fields in a table rather than
listing
> each field out on it's own line in the BEGIN-SELECT statement?
>
> Also does anyone know if you can insert spaces for values for a bunch of
> fields that are right next to each other. Right now I enter Let
<fieldname>
> = ' ' for about 20 different fields that are all in order. So my code gets
> very long.
>
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
> Maria K Brickl
> Information Systems Programmer/Analyst
> University of Wisconsin Colleges
> 780 Regent St, PO Box 8680, Madison, WI  53708-8680
> Phone: 608.265.2677 / Fax: 608.265.5770
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
>