Can We Create a Synonym On Trigger?

Answer Posted / anang

Yes We can create a synony for a trigger like this

Create or replace trigger test before insert on emp
begin
dbms_output.put_line('Hi');
end;
Create the trigger in scott schema

and connect to apps schema and create a synonym like this

create public synonym test for scott.test;

or

create synonym test1 for scott.test;

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to move the one file from one instance to another instance? And your scripts also?

826


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1971


How to create a purchase order without a requisition?

848


Are you familiar with internet architecture of oracle apps 11i?

823


how do you describe O2C along with tables

2511


Can you define an erp system?

881


Can you explain the difference between architecture followed in 10g & 11g?

855


Explain oracle apps architecture.

1001


How is choreography different from orchestration?

884


Which oracle apps version you are very confident in?

936


List the various types of value set.

809


Can we create tables in apps schema?

844


please send me forms, xml pulisher questions,answers

1885


What are the different components of soa suite?

924


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2151