Before/After sql

[madhonrougeuri]

Hi,
Could any body tell me in what case is before/after sql used in OCI stage..any examples?

Thanks.

[denzilsyb]

I do think there are many applications of the before/after subs, but one could be to check the value of a column in another table and depending on that value something could happen to the input column... far fetched though...

I do not think before and after for a stage is the best thing because every row is evaluated against the before/after routine, so the I/Os could easily becme tedious and slow down the process.

[kcbland]

Hi,
Could any body tell me in what case is before/after sql used in OCI stage..any examples?

Thanks.

For Oracle, you could find uses such as:

Code: Select all

ALTER SESSION DISABLE PARALLEL QUERY;

Or

Code: Select all

ALTER SESSION ENABLE PARALLEL DML;

Or

Code: Select all

Grants, Drops, Creates, Stored Procs, etc

[denzilsyb]

a double gargle blaster!

thats one helluva drink KC!

[kcbland]

http://hitchhikers.movies.go.com/main.html

[madhonrougeuri]

Thanks...

[sck]

Suppose if no rows were processed that is the number of rows to the input link (lets take the case of error processing then) will the after SQL still get executed???

Thanks
SCK

[wnogalski]

Yes.