Thread: Need some advice on SQL script
07-17-07, 11:08 #1Registered User
- Join Date
- Aug 2006
Unanswered: Need some advice on SQL script
I am new to SQL scripting. But I need to write a script to do some insert statements. I am using 10g, so I can use Oracle specific command. I made a tester script to try to understand the behavior of this language, but I am having some problems with it.
I get an error: "SQLPLUS Command Skipped: set sqlblanklines on" and so on with all set commands.
Also, I do need to control the transactions because I want to use multilple insert statements in the same script.
This is what I have so far...
set sqlblanklines on
set termout off
set head off
set pause off
set termout on
set auto off
set autot on
insert into trat_work (strategy_code, planning_code, associated_by, associated_on, percentage_share)
strat.structure_code, prj.structure_code, 'ADMIN', sysdate, '100'
07-17-07, 11:43 #2Registered User
- Join Date
- Jun 2003
- West Palm Beach, FL
Ooops are you using iSQL*Plus?.
Some commands are not supported in iSQL*Plus
Last edited by LKBrwn_DBA; 07-17-07 at 11:48.The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb