Query for trigger in SQL Plus

30 pts.
Tags:
Oracle triggers
SQL Plus
How can I define a trigger that will fired to calculate gpa at run time before the insertion of record into table?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You need a “BEFORE INSERT” trigger.

A Google search would return lots of examples.

Here is the official documentation:  Using Triggers

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Have you written a trigger code for this purpose? What database are you using now? Some syntaxes/code may vary depending on databases. However OS is not so important here, but recommended to disclose here. You can back with your code that helps you to get more good replies.
    86,760 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: