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
Do you know what are user profiles in apps. Any examples you can give?
can we get profile values in report without using user exists is it possible how?
tell me the scenarios of the independent in reports
What is oracle soa suite and what are its different components?
How do you register report in oracle apps?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Plz anybody send me Technical specification for AP Interface
q)what are the validations in sql*loader
Do you know what is applysys in oracle application database schema, what is apps?
testing tools?
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
Which oracle apps version you are very confident in?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
how can i print random rows in plsql table