RE: SQL question

Raj,

It wasn't a question of coding the sql to create all of the unions, but hitting a limitation on the number of unions in the sql.

But, thanks to all for the effort.

steve

• "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
  > Steve,
  >
  > select 'select a.code ' || chr(10) || ' from('
  > ||
  > from dual
  > union
  > select distinct 'select ' || '''' || code ||
  > '''' || ' code from dual ' ||
  > chr(10) || 'union' ||
  > from my_code_table
  > union
  > select ')' || chr(10) || 'minus' from dual
  > /
  > select 'select distinct code from my_table' ||
  > chr(10) || '/'
  > /
  >
  >
  > drop off the last union before the closing
  > parenthesis ...
  >
  > See ... now you don't have to type ...
  >
  > Raj
  >
  

  ---

  
  > Rajendra Jamadagni MIS, ESPN Inc.
  > Rajendra dot Jamadagni at ESPN dot com
  > Any opinion expressed here is personal and
  > doesn't reflect that of ESPN Inc.
  >
  > QOTD: Any clod can have facts, but having an
  > opinion is an art!
  >
  >
  > -----Original Message-----
  > From: Steven Haas [mailto:steven.haas_at_snet.net]
  > Sent: Monday, September 23, 2002 1:38 PM
  > To: Multiple recipients of list ORACLE-L
  > Subject: RE: SQL question
  >
  >
  > Dan (and Charlie),
  >
  > Thanks.
  > Good suggestions, but the IN clause contains
  > just
  > over 1700 values.
  >
  > Puzzling, huh?
  >
  > steve
  > >
  ********************************************************************This
  > e-mail message is confidential, intended only
  > for the named recipient(s) above and may
  > contain information that is privileged,
  > attorney work product or exempt from disclosure
  > under applicable law. If you have received this
  > message in error, or are not the named
  > recipient(s), please immediately notify
  > corporate MIS at (860) 766-2000 and delete this
  > e-mail message from your computer, Thank
  >
  you.*********************************************************************2
  >
  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Haas
  INET: steven.haas_at_snet.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).