Export Oracle table data to text file !!

[fibreclaw]

Hi All,
I am a new entrant into PLSQL tech. I am postin this ver common query. I wish I'l be able to post a more precise quesry next time.

This is it : I need to extact oracle table data on to a text file with pipeline as delimiter .

Any advice on this wil be really helpful and thanks a lot for those who hv spared a bit of their time .:)
Thank you

[debasisdas]

try to use the spool command for the purpose

else you can easily do that by using TOAD.