Re: sqlplus problem

From: Jianping Zhu <jzhu_at_fisher.forestry.uga.edu>
Date: Thu, 01 May 2003 19:11:36 -0800
Message-ID: <F001.0058DD2E.20030501191136@fatcity.com>

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");

---

   insert into customer values("an", "bn");

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