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
Configure parameters through commands (Read 1634 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Configure parameters through commands
01.02.06 at 17:01:12
 
Commands can be used to configure parameters.  
 
There are three ways to configure parameters / variables in SQL:

The following SQL commands can be used:

 
See also:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1138895880
Back to top
 
« Last Edit: 02.02.06 at 17:14:27 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Configure parameters through commands
Reply #1 - 24.02.06 at 15:41:51
 
The variable command was extended today to also define the size of a varchar parameter.  
Example:
 
variable myvar varchar(500);
 
See:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1140791693
http://www.oraxcel.com/projects/sqlxl/help/commands/variable.html
Back to top
 
 

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