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
Bytes retrieved from CLOB (Read 3622 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Bytes retrieved from CLOB
07.09.09 at 14:13:06
 
Bytes retrieved from CLOB
 
CLOB handling in the SQL*XL software is improved. When querying CLOB data into Excel the values were truncated to 100 bytes. This has now been made variable through the long variable. Standard this is set to 80 but by running the set command this value can be changed:
 
The following command, which is executable through the SQL screen just as ordinary SQL commands, will set the long variable to 1000. After setting long to 1000 all queries that return CLOB or long values will return 1000 bytes.
 
set long 1000;
 
You can mix the set long xxx; command with your SQL. For example the following set of commands will execute a first select statement using a long value of 100 and a second select statement using a long value of 200:
 
set long 100;
select * from my_long_test;
set long 200;
select * from my_clob_test;
 
This feature is available from SQL*XL 4.3.17
 
See also:
SQL*XL release log
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130772637
Set Command
http://www.oraxcel.com/projects/sqlxl/help/commands/set.html
Control how Long Varchar columns are displayed
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1135939951
Back to top
 
 

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