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
How to move the one file from one instance to another instance? And your scripts also?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How to create a purchase order without a requisition?
Are you familiar with internet architecture of oracle apps 11i?
how do you describe O2C along with tables
Can you define an erp system?
Can you explain the difference between architecture followed in 10g & 11g?
Explain oracle apps architecture.
How is choreography different from orchestration?
Which oracle apps version you are very confident in?
List the various types of value set.
Can we create tables in apps schema?
please send me forms, xml pulisher questions,answers
What are the different components of soa suite?
how can develope the po variance and po summary report? with tables mandatory columns and query please?