I am creating a simple output from sqlplus running a select and spooling it to a file. If I want the columns to be delimitted by a tabchar, how would I do that? I do not want to do 'select col1 || ' ' || col2 || from tablename'.
I want to be able to use a variable name in place of ' '.
How do I define it?
Thanks in advance.