Re: unloading text and loading text.

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)

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 Sat Dec 09 2000 - 00:46:44 CET