insert data [message #70461] |
Mon, 17 June 2002 07:27 |
Joe Benaoso
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
I HAVE TO INSERT DATA IN A BOARD THAT HAS 720 FIELDS, AS I CAN DO TO INSERT DATA OF ONCE WITHOUT HAVE TO DO UPDATE
|
|
|
Re: insert data [message #70481 is a reply to message #70461] |
Wed, 19 June 2002 16:30 |
Siva Ram
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hi Jose
Could you please let me know what you want to do ?
If you want to insert data for 720 fields at a time, store the data in a .SQL file and execute it like
SQL> ed boarddata.sql
INSERT INTO BOARD VALUES (value1, value2 ...);
INSERT INTO BOARD VALUES (value1, value2 ...);
INSERT INTO BOARD VALUES (value1, value2 ...);
INSERT INTO BOARD VALUES (value1, value2 ...);
COMMIT:
...
save the file and execute from SQL prompt as
SQL> @ boarddata.sql OR SQL> start boarddata.sql
Thank you
Siva Ram
|
|
|