Oracle if inserting or updating

6854933580_2c8b688306_z

Your job’s a joke, you’re broke, your love life’s DOA. And when it hasn’t been your day, you week, your month, or even your year.

[*That wise man me; but stick with me, I promise to bring this back around to Oracle SQL imminently.

A wise man* once said: So no-one told you life was gonna be this way.The music is loud, the atmosphere is great, and a good time is had by everyone. Oh, and you had a big fight with new Ross and decided you no longer want to be friends with him.You wake up the next morning with a bit of a sore head and try to recall everything that went on the night before: you’d discovered that Chandler’s middle name is Muriel, and that Ross’ is Eustace. You roll out of bed and groggily wipe your eyes: all this new information needs recording; you’d better fire up your database.Concurrent calls to the database uses the undo stack; so Oracle will manage the final state based on the order of when the concurrent transactions started/completed.The CREATE TRIGGER statement has a lot of permutations, but the vast majority of the questions I'm asked relate to basic DML triggers.] So – since it hasn’t been your day, your week, your month, or even your year – you decide to go to Central Perk with your friends Ross, Rachel, Monica, Phoebe, Chandler and Joey.

You must have an account to comment. Please register or login here!