Re: Load/unload utilities

[Quoted] The LOAD statement is used to insert data from an operating-system file into an existing table and the DELIMITER clause specifies the delimiter that separates the data contained in each column in a row in the LOAD FROM file. The syntax for the load command is as follows:

    LOAD FROM ' filename'
    DELIMITER 'delimiter'
    INSERT INTO 'table_name' (column_names)

This is an example of an input file:
0|Jeffery|Padgett|Wheel Thrills|3450 El Camino|Suite 10|PaloAlto|CA|94306|| 0|Linda|Lane|Palo Alto Bicycles|2344
University||PaloAlto|CA|94301|(415)323-6440

This load functionality is particularly useful when bulk importing data from another system, or when exporting data into a tab delimited format for opening in MS-Excel for example.

The documentation for the UTL_FILE and DBMS_UTILITY functionality does not appear to extend similar delimitation handling. Can you conform.

Waseem Qaraguli

damorgan wrote:

> What is file delimitation? If you can provide a complete explanation ...
> I'm sure we can tell you how to do it.
>
> But I can tell you that Oracle export/import has nothing to do with
> exporting and importing data. It is a tool for backing up and restoring or
> moving data and tables. Likely you will want to look at SQL*Loader,
> UTL_FILE, DBMS_LOB, and DBMS_UTILITY.COMMA_TO_TABLE and
> DBMS_UTILITY.TABLE_TO_COMMA for the functionality you seek.
>
> Daniel Morgan
>
> "Qaraguli, Waseem [QUAL:C923:EXCH]" wrote:
>
> > Is there equivalent functionality in Oracle to Informix's LOAD/UNLOAD
> > SQL commands that allows for file delimitation? It appears that Oracle
> > does not support this command!!!
> >
> > Can someone point me to the docs that deal with Oracle export/import
> > tools for delimited files.
> >
> > Thanks,
> > Waseem Qaraguli
Received on Thu Feb 28 2002 - 19:06:17 CET