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
Ignore ampersands in a SQL script (Read 1187 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Ignore ampersands in a SQL script
19.05.15 at 13:23:24
 
Ignore ampersands in a SQL script
 
An ampersand character & is used for bind variables. However sometimes it appears in a string value and you don't want to use the bind variable feature. You can switch it off by escaping the & character.
Run the SQL*PLus command: set escape on;
Then escape the & character with a back slash.
 
Example:
set escape on;
select * from mytable where mycol='hello\&world';
Back to top
 
 

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