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
Accept command: prompt for parameter value (Read 4223 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Accept command: prompt for parameter value
25.10.05 at 17:21:51
 
Support was added for the accept SQL*Plus command:
 
ACCEPT variable_name PROMPT text;
 
You can use this command in SQL*XL to prompt for values of substitution variables.  
Example:
 
ACCEPT myempno PROMPT 'Enter an employee number';
select * from emp where empno = &myempno;
 
See also:
http://www.oraxcel.com/projects/sqlxl/help/commands/accept.html
http://www.oraxcel.com/projects/sqlxl/help/techniques/parameters.html
Back to top
 
 

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