INSERT ROWS

From: <gspatel_at_pepco.com>
Date: Fri, 19 Oct 2001 10:58:04 -0700
Message-ID: <F001.003B04BC.20011019111520@fatcity.com>

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

Received on Fri Oct 19 2001 - 12:58:04 CDT