Linker IT Software
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 3583 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
Set Command
Control how Long Varchar columns are displayed
Back to top

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