Before and after in ora stage

ranga1970 · Post by **ranga1970** » Mon Apr 25, 2005 3:23 pm

Can I place a
1 .truncate scripts in before in SQL in ORAOCI stage
2 .SQL scripts in after in SQL in ORAOCI to perform some comparion?
I had used before job sub routens and after job sub routens previously but neve used Before and after in ORAstage, just want to try some thing new and jist wondering if I could carry out 1 and 2 steps I mentioned,

Thnaks

kcbland · Post by **kcbland** » Mon Apr 25, 2005 7:55 pm

You can write anonymous block stored procedures, execute ALTER commands, etc, and execute stored procedures.