This content has been marked as final. Show 2 replies
the html editor shows the output of testcase 1 and 2 as the same. But when you try the testcase you can see the the output of testcase 2 is filled up with blanks in each varchar2 column...
You are going to use the Sqlloder for spooled file.. you can use the column separation rather the using the fixed character length..
you can use in simple way
set colsep ";" or set colsep "|"
select * from test;