Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hr@tgksolutions.com
A trigger is a block of PL/SQL code automatically executed in response to certain events (e.g., INSERT, UPDATE, DELETE) on a table.
Example Trigger:
CREATE OR REPLACE TRIGGER EmployeeAudit
AFTER INSERT ON employees
FOR EACH ROW
BEGIN
INSERT INTO audit_log(employee_id, action, action_date)
VALUES (:NEW.id, 'INSERT', SYSDATE);
END;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger price?
Is left join inner or outer by default?
What are the different types of sql commands?
What is trigger in sql? Explain
What does the argument [or replace] do?
Show the cursor attributes of pl/sql.
What is the maximum number of triggers, you can apply on a single table?
How does an execution block start and end in pl sql?
What does the hierarchical profiler does?
What is auto increment feature in sql?
How to look at the current sql*plus system settings?
What is linq to sql?
Which operator is used in query for pattern matching?
What are pl sql procedures?
When sql appeared?
