Pl sql if inserting updating

:old.sal); dbms_output.put(' New salary: '

-- CREATE OR REPLACE FUNCTION maint_sales_summary_bytime() RETURNS TRIGGER AS $maint_sales_summary_bytime$ DECLARE delta_time_key integer; delta_amount_sold numeric(15,2); delta_units_sold numeric(12); delta_amount_cost numeric(15,2); BEGIN -- Work out the increment/decrement amount(s).You might omit this clause if you just want to record the fact that the operation occurred, but not examine the data for each row.Once the trigger is created, entering the following SQL statement: A trigger is either a stored PL/SQL block or a PL/SQL, C, or Java procedure associated with a table, view, schema, or the database itself.Trigger names do not need to be unique with respect to other schema objects, such as tables, views, and procedures.For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended).

Leave a Reply