Re: unloading text and loading text.

for example, you want to spool the data to a file. you may type the followings in sqlplus.

set head off
spool test.txt
select firstname||','||lastname||','||userid from <table_name>;
spool off

Then the file test.txt will contain what you want.

Ken

"Lamar Williams" <lamar_at_moOFus.com> ????? news:3A3172E4.E944B583_at_moOFus.com...
> Any examples for option 1? Using comma seperated data.
>
> given the following table:
>
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> FIRSTNAME NOT NULL CHAR(32)
> LASTNAME NOT NULL CHAR(32)
> USERID NOT NULL CHAR(10)
>
> and a data file like the following
>
>
> Lamar,Williams,8834
> Joey,Thebest,83
> Connie,isInTrouble
>
>
>
> Thanks,
> Lamar
>
> Alexander Medvedev wrote:
>
> > Lamar Williams wrote:
> >
> > > What is the best way to unload a table into a human readable text
 file,
> > > and then
> > > load it back into my table (assumming I clean the table first)?
> > >
> > > I'm experience with Informix, but new to Oracle.
> > >
> > > Thanks,
> > >
> > > Lamar_at_moOFus.com
> >
> > Hi Lamar,
> >
> > There are several ways to do it.
> >
> > 1) unload to file by SQL*Plus, load by SQL*Loader
> > 2) using UTL_FILE package (set of stored procedures, suplied with
 Oracle) -
> > only on server disk, not on the client machine. UTL_FILE can open files
 for
> > read and write both.
> > 3) unload by Oracle Report, load by SQL*Loader
> > 4) unload and load by Oracle Forms (you have to use text_io package in
 your
> > form)
> > 5) One of OAS, OWA, WEBDB on server side and browser on client side.
> > 6) Write a simple program by some language you want (VB, C, C++, Power
> > Objects, etc)
> > 7) By some third-party tool (like MS Excel, for example) can interact
 with
> > Oracle via ODBC driver
> >
> > and so on...
> >
> > Also you can make a simple (default) form by Form Builder (its a part of
> > Developer2000, Developer-6) to query and manipulate data in your table
 in
> > dialog.
> >
> > Regards Alexander Medvedev
>
Received on Sun Dec 10 2000 - 09:11:54 CET