Database Administration (MOSC)

MOSC Banner

Would LIke a Review of My Trigger for Efficiency

edited Oct 19, 2012 6:42AM in Database Administration (MOSC) 12 commentsAnswered ✓

Hi Folks

I have created a trigger that seems to work but I would like to ask anyone that has written triggers if i
have created this one in the most efficient manner.

I have very little experience writing triggers at this time, so would appreciate any opinions
on my code.

Basically, the trigger is set on a table called dauditnew that fires when a record is inserted with an auditstr='Login'

It then either inserts a record or updates an existing record in a table called ll_last_logon

Thanks
Jim

CREATE OR REPLACE TRIGGER ll_last_logon_insert

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center