Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus: How can I write each record to a separate file
I started writing out an example, but there are too many options
depending on how you want to deliver this. If you have a specific
question then someone can answer it.
It goes from setting up environment variables in SQL Plus (ex: define
slash = "/")
to the solution Sybrand Bakker suggested (exp rows=n).
Sorry to be so vague, but a cool approach in one situation can lead to bad practise that is hard to maintain in another delivery model. Received on Fri Sep 08 2006 - 15:15:11 CDT
![]() |
![]() |