Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by manojbajaj
-
trigger and multiple procedure?
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- manojbajaj
- Post #2
- Forum: Oracle: All versions
-
oracle packages
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- manojbajaj
- Post #2
- Forum: Oracle: All versions
-
Stored procedure
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- manojbajaj
- Post #5
- Forum: Oracle: All versions
-
Date information
It's very simple Pleas use this Add_months(max(date),- 6 ) from ..... Manoj Bajaj- manojbajaj
- Post #5
- Forum: Oracle: All versions
