Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle subquery factoring support (Read 3949 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle subquery factoring support
16.03.06 at 09:49:30
 
SQL*XL users can now make use of the Oracle subquery factoring syntax. This syntax places a WITH clause before the select statement. You can assign a name to a query block and use that mulitple times later in the actual select statement. This is handy when you are summarising and want to continue with the summarised results.
 
Please see the following post for a further description and example:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1142498392
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1