Answer Happy

Q1: Triggers are the SQL statements that are automatically executed when there is any change in the database. The triggers are executed in response to certain events(INSERT, UPDATE or DELETE) in a particular table. Give the PL/SQL code perform the following tasks a) Create a table b) Create a Trigger for the any event c) Show the execution of trigger Q-2 : Cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. Give the PL/SQL for a) Implicit Cursors b) Explicit Cursors Q-3: A join clause is used to combine rows from two or more tables, based on a related column between them. Explain the joins, taking the example of your own.