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
can we get profile values in report without using user exists is it possible how?
What is a flexfield? List out its types.
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
Can you define an erp system?
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
what is pay run id ?
What does appl_top directory contain?
How to create a purchase order without a requisition?
tell me the scenarios of the independent in reports
How can we import the data into a database using sql * loader?
What is oracle soa suite and what are its different components?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Tell me where we find the status of order information?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Are you familiar with internet architecture of oracle apps 11i?