HowDoI create csv files for sqlldr testing?

[raygg]

HowDoI create csv variable length test files to simulate very large files that will be loaded via sqllder? The twist is that instead of commas as the separator the files use x'1c'.

 

[MikeJones]

Would a spool on a SQL statement work??

i.e. select col1||'x''1c'''||
col2||'x''1c'''||
from ....

if you wanted to limit the size of the file produced then you could stick a &quot;and rownum < X&quot; at the end of the query.

 

[karluk]

If I understand the question you can create the file ok, but are wondering how to generate the x'1c' values as separators. I think x'1c' is equivalent to chr(28), so maybe you can adopt Mike's spool suggestion with this function.

select col1 || chr(28) || col2 ...