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
Support for the Oracle WITH clause (Read 4051 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Support for the Oracle WITH clause
03.11.07 at 22:04:41
 
Support for the Oracle WITH clause
 
Running queries with the new Oracle WITH clause sometimes did not work correctly. A fix was put into SQL*XL 4.2.5 to fix this.
 
The Oracle WITH clause enables the calculation of results that can be used in other parts of the query. The basic syntax is: WITH name as (query) SELECT ....
 
Also see:
Oracle subquery - With syntax
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