can i create trigger on synonym is it possible or not please help me

Answers were Sorted based on User's Feedback



can i create trigger on synonym is it possible or not please help me..

Answer / neelu

Yes.

create or replace trigger trg_test
before insert on emp
begin
null;
end;

create synonym trg_syn for trg_test;

Is This Answer Correct ?    6 Yes 4 No

can i create trigger on synonym is it possible or not please help me..

Answer / suman

Yes u can create trigger on synonym
below are example
select * from scott.emp;

select * from sy_emp;
create or replace synonym sy_emp for scott.emp;

/
create or replace trigger t_name
after insert on sy_emp
begin
null;
end;
/

Is This Answer Correct ?    2 Yes 0 No

can i create trigger on synonym is it possible or not please help me..

Answer / akhil

hi neelu.
question is "Can I trigger on synonym'
but you have answered for the question "Can I create synonym for trigger"(your answer is correct for this question)


my understanding about the real question is
we have create synonym for the table,then is it possible to create trigger on that synonym.

If my understanding is wrong,forgive me.

Is This Answer Correct ?    1 Yes 0 No

can i create trigger on synonym is it possible or not please help me..

Answer / shailesh

Yes, the trigger can be created on synonym. However, this trigger gets created on the respective base table for which the synonym is created.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what are the limitations of identity column? : Transact sql

0 Answers  


How long it takes to learn pl sql?

0 Answers  


Is json a nosql?

0 Answers  


What are the advantages of normalization?

0 Answers  


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  






What are the two types of cursors in pl sql?

0 Answers  


I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,


What is a native sql query?

0 Answers  


What is user in sql?

0 Answers  


I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  


What is blind sql injection?

0 Answers  


How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,


Categories