Hi,
You can write before insert,update,delete trigger on table and when inserting or updating u call check_sal and autdit
when deleting u may call only audit. for sepcifc syntax refer to any oracle book
Hi,
You can have a look at DBMS_SQL package provided by Oracle
this is basically to execute dynamic sqls . U can pass
procedure & directory name as parameteres...
Manoj
This again very Simple . Please use this
update test_fund
set whatever_needs_to_be_updated
where olyid = p_olyid etc,etc;
IF SQL%NROWS <= 0 Then
INSERT INTO....
End If;
Here Keyword SQL Acts as a Implicit cursor Name and NROWS
is its property..
Manoj
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.