Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: building sets in SQL92

Re: building sets in SQL92

From: --CELKO-- <joe.celko_at_trilogy.com>
Date: Sat, 21 Jul 2001 23:31:26 GMT
Message-ID: <7e67a7b3.0106181126.1c26c6ec@posting.google.com> 






In full SQL-92 you could write:
 


(VALUES ('Boston'), ('Atlanta'), ('Columbia')) AS Cities(city)name)



The VALUES() statement is now generalized (orthogonalized?) to create
tables and not just single rows.  Most products donot have this yet,
so you might have to use UNION ALL to put the rows into your working
table.
Received on Sat Jul 21 2001 - 18:31:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US