| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlplus problem
On Thu, May 01, 2003 at 07:51:50AM -0800, DENNIS WILLIAMS wrote:
> Jianping
> There are several ways to accomplish this. If it is a lot of records,
> consider SQLLoader. It can read flat files of various formats. Do you
> already have these records in a file?
>
> Dennis Williams
> DBA, 60%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Thursday, May 01, 2003 10:17 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I need to insert lots of record into a table. it it very tedious to type
> in the commnad like this
> sqlplus> insert .....
> sqlplus> insert .....
> .......
> sqlplus>insert.....
>
> I guess i can put the queries in a script then execute it (like in mysql
> i can create a ins.sql script then use source ins.sql to insert all
> recond) i am very new to oralce. and do not know how to do it. Can
> someboday give me some hints?
>
> Thanks
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jianping Zhu
> INET: jzhu_at_fisher.forestry.uga.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
Thank you for reply.
I do not have any file yet. i will have a files called insert.sql which contain insert statememet:
insert into customer values("a1", "b1"); insert into customer values("a2", "b2");
is there a way by which i can execute insert.sql to insert this row to table? in mysql i can use source insert.sql. to do that, in oralce, is there a simple similar way to do that?
> ---------------------------------------------------------------------
> 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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jianping Zhu INET: jzhu_at_fisher.forestry.uga.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Thu May 01 2003 - 22:11:36 CDT
 |
 |