I am an Oracle guy new to sybase. The sybase version I am using is 11. The sybase database client I use to query tables is SQL Advantage. How can I produce an ascii text file of my table with the fields delimited by |(pipe).
What actually I am trying to do here is produce the pipe delimited file of the data which I can use to load into Oracle(using Oracle's sql loader)
Any tips is appreciated