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
What is a value set? List its various types.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is the difference between request group and request security in oracle apps?
Tell me where we find the status of order information?
What do you understand by a set of books?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
How can a process be deployed in soa?
How to move the one file from one instance to another instance? And your scripts also?
What are file in oracle.
Do you know what are user profiles in apps. Any examples you can give?
Can you differentiate between mediator and osb?
What are the benefits of using soa architecture?
what are the different transaction clauses in AR?
Can you define an erp system?
can we get profile values in report without using user exists is it possible how?