Yes. create or replace trigger trg_test before insert on emp begin nu

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

Question Posted / neelu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Does a primary key have to be a number?

961

Inline the values in PL/SQL, what does it mean.?

1214

what are properties of a transaction? : Sql dba

1090

What is the difference between sum and count in sql?

984

how to include character strings in sql statements? : Sql dba

1063

Does truncate table reset auto increment?

989

How insert into statements in sql?

1067

How do I write a cron which will run a sql query and mail the results to agroup?

971

What is the difference between local variables and global variables?

1121

explain the options of myisamchk to improve the performance of a table. : Sql dba

1004

What is the use of procedures?

971

How do I count rows in sql query?

985

How many unique keys can a table have?

1009

What are the types of join in sql?

1095

what is uncommittable transactions? : Transact sql

994