Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute INSERT statements from txt file ...

722012Sep 15 2009 — edited Sep 15 2009
Hello everyone,
1. Is there anyway to execute ready insert statements that are defined in .txt file by "sqlplusw" ?. I have around 4000 statements.
2. When I make a copy/paste from .txt file to sqlplusq only 15 lines are being copied a executed even though I select more than 100 line statements. How to make them pasted all selected lines ?.

the .txt file structure like
INSERT INTO PERSONEL.DPTRANSLATIONS (TID,SCRIPT_NAME,TAG,TR,EN,LOCAL) VALUES (PERSONEL.SQX_TID.NEXTVAL ,'DELPHI.OGIS.frmOgr.pnlTop.Panel1.pgOgr.tbsDisiplin.LMDGroupBox23.Label104','Label104','Suç','Suç_eng','Suç_loc');
INSERT INTO PERSONEL.DPTRANSLATIONS (TID,SCRIPT_NAME,TAG,TR,EN,LOCAL) VALUES (PERSONEL.SQX_TID.NEXTVAL ,'DELPHI.OGIS.frmOgr.pnlTop.Panel1.pgOgr.tbsDisiplin.LMDGroupBox23.Label199','Label199','Açıklama','Açıklama_eng','Açıklama_loc');
...
thank you.
This post has been answered by ravikumar.sv on Sep 15 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2009
Added on Sep 15 2009
11 comments
2,308 views