Creating Fixed length Text file from Oracle 9i table.
I am trying to generate a fixed length text file from Oracle 9i table.
My expected output is
1-10 First Name
11-20 Last Name
My output is going to look like this:
Steveson Cathy Washington DC
Robbs Valles Maryland
What is best way i can do, UTL_FILE or Spool or some other approach? If so how to do?