Hi,
You can use UTL_FILE or SQL*Loader utilities.
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com
> -----Original Message-----
> From: gspatel_at_pepco.com [SMTP:gspatel_at_pepco.com]
> Sent: Friday, October 19, 2001 01:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: INSERT ROWS
>
>
> I AM LEARNING ORACLE.....
>
> I CREATED A TABLE JUNK AS BELOW,
>
> SQL> CREATE TABLE JUNK
> 2 (NAME VARCHAR2(10),
> 3 EMPID NUMBER(5) ,
> 4 SALARY NUMBER(5,3) ) ;
>
> Table created.
>
> I NEED TO INSERT " C:|JUNK.SQL " ( I SAVED IN NOTEPAD ) WHICH LOOKS AS
> FOLLOWS :
> HOW SHOULD I DO THAT ?
>
>
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
> ABCDEFGHIJ 12345 999.99
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guidry, Chris
INET: chris.guidry_at_atcoelectric.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Oct 19 2001 - 15:49:05 CDT
