Re: sqlplus problem

Where are you getting your data from? The answer depends on the data source.l

>>> jzhu_at_fisher.forestry.uga.edu 05/01/03 10:16AM >>>
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: John Shaw
  INET: John.Shaw_at_correctionscorp.com

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).