INSERT ROWS

[gspatel]

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