oracle batch/scripts

[Nordyck]

I'm attempting to build update.sql file that updates several tables with the same values. Update file is executed from a batch file.

file: update.sql
------------------
dte date := systimestamp;
st varchar2 := "test";
/
update tbl1
set Source=st,
ProcessDate=dte
where ProcessDate is null;
/
update tbl2
set Source=st,
ProcessDate=dte
where ProcessDate is null;
/
update tbl3
set Source=st,
ProcessDate=dte
where ProcessDate is null;

test.bat file:
-----------------
sqlPlus user/pw @Update.sql

Thanks in advance.

nordycki@hotmail.com

 

[taupirho]

Nearly, you fell between the sqlplus and pl/sql stools

declare
dte date := systimestamp;
st varchar2(4) := "test";
begin
update tbl1
set Source=st,
ProcessDate=dte
where ProcessDate is null;
update tbl2
set Source=st,
ProcessDate=dte
where ProcessDate is null;
update tbl3
set Source=st,
ProcessDate=dte
where ProcessDate is null;
end;
/
exit


In order to understand recursion, you must first understand recursion.

 

[Nordyck]

thanks, that worked great.

nordycki@hotmail.com