Hi Every1

I have problem in Trigger.I am new for that.Pls help me.

I have one table as Try.When I insert values in Try,at a time I want to fire Trigger for inserting and insert that value also in another table as Try1.

I got help but not understand why create temporary table in Trigger.Can we use direct table name in Trigger?

Pls help me if u have solution for triggers.Becoz I am completely new in this concept.

Thanks
monika

hi monika,

the simplest of the code for your task could be

create or replace trigger
trigg_try_update before insert
on try
for each row
begin
insert into try1(x,y) values (:new.x,:new.y);
end;


here x and y are the columns(place whatever columns your table has) of the table try1 in which u want to insert values before inserting them to table try.

the default practise is to use pseudo names :new and :old to reference the new and old value of the table on which the trigger
is fired.{ remember that :new and :old cannot be used in case
of table level triggers }.

Hey Monica,

vijaykpit is right in case os ANSI SQL (used by ORACLE)

but if u r using SQL SERVER (T-Sql) then u won't find :new & :old bind varibles. Instead T-SQL provides two temporary system tables(INSERTED and DELETED) that hold the data used in the query. INSERTED table is used for INSER and UPDATE triggers, whereas DELETED is used in case of DELETE trigger. The structure of these tables are same as the table u r acting upon. U can query these table in the same manner as...
SELECT * FROM INSERTED


IN YOUR CASE, U should select the values from INSERTED table and INSERT these into TRY1 within The Trigger Body

Akhil