OraFAQ Forum: SQL & PL/SQL » Tab-delimited output

Home » SQL & PL/SQL » SQL & PL/SQL » Tab-delimited output

Fri, 06 December 2002 20:34

Mark
Messages: 284
Registered: July 1998

Senior Member

Is there a way to spool out data in tab-delimited format ?

Thanks

Sat, 07 December 2002 10:32

Aarty
Messages: 4
Registered: November 2002

Junior Member

Hi,
Try this;

spool 1.lst;
select empname||chr(9)||sal from emp;
spool off;

Previous Topic:	How to find Time zone.
Next Topic:	regarding tablespace size

Goto Forum:

]

Current Time: Thu May 16 18:59:03 CDT 2024