Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Oracle Data Warehouse Design Creating An SQL Generating Front End
Listing 4.2 A REXX routine to generate SQL from screen values.
/* ------------------------------------------
Add SQL command to input stream...
------------------------------------------ */
sql_write:

queue "SET CURRENT SQLID = 'AUTOC';"

if XBILL = ' ' &,
XSNUM = ' ' &,
XDATE = ' ' &,
XSITE = ' ' &,
XADDR = ' ' &,
XCITY = ' ' &,
XSTATE = ' ' &,
XZIP = ' ' &,
XACCT = ' ' &,
XACTIVE = ' ' &,
XREQ = ' ' &,
XTIME = ' ' &,
XTYPE = ' ' then
queue "SELECT * "
else
queue "SELECT "

COMMA = ' '

if SUMMARY ^= ' ' then
do

/* add summary stuff here */

if XACCT ^= ' ' then
do
queue " TOT_USER_SITES"
COMMA = ','
end

if XACTIVE ^= ' ' then
do
queue COMMA " ACTIVE_USER_SITES"
COMMA = ','
end

end

if XDATE ^= ' ' then
do
queue COMMA " DATE_YYMM"
COMMA = ','
end

if XSITE ^= ' ' then
do
queue COMMA " NAME_LINE_1"
COMMA = ','
end

---

This is an excerpt from "High Performance Data Warehousing". To learn more about Oracle, try "Oracle Tuning: The Definitive Reference", by Donald K. Burleson.  You can buy it direct from the publisher at 30% off here:
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm