Hi Gurus,
I had a problem writing a pipe file.
Previously i used this code to generate a tab seperated file
ABCEF := ABCEF || 'to_char('|| abc_tab(col_num).col_name || ') chr(9) || ';
Now i want the o/p as pipe seperated file.I changed the line as below
ABCEF := ABCEF || 'to_char('|| abc_tab(col_num).col_name || ') chr(124) || ';
But it throwing an error not able to concate '|"
can u plz help me out how to put pipe as a delimiter to get the o/p
Regards,
San