w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
sqlplus save to file doesnt work on big fields

The column is probably a CLOB or LONG datatype.

Try adding SET LONG 10000 to the top of your .sql script. The number can be adjusted, but I believe there is a limit.


You may also want to increase your line size with SET LINESIZE 300 (whatever size works for you).

You also should trim trailing blanks.

SET TRIMOUT ON trims trailing blanks from screen output.

SET TRIMSPOOL ON trims trailing blanks from spooled output.





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.