Home » Server Options » Streams & AQ » Triggers and Streams (Oracle)
Triggers and Streams [message #415820] Wed, 29 July 2009 07:43
patil.vishwa
Messages: 7
Registered: December 2006
Location: Bangalore,India
Junior Member
Hi,

Can i have your thoughts on this, Please?

Let us say, I've a trigger on EMP table which fires on any inserts and copies that new record to other table.
Can streams do the same job effectively?

If yes, which one would be the better option in terms of performance?

Thanks in advance.

Cheers,
Vishwa





Previous Topic: Calling procedure with a different user (merged)
Next Topic: steam re-instantiation
Goto Forum:
  


Current Time: Thu Mar 28 15:58:13 CDT 2024