| Ruby on Rails instal… on How to install Ruby On Rails r… | |
 | john rich on DotA Heroes Pool |
 | Michael on hackertest.net level 1 –… |
 | membrane on hackertest.net level 1 –… |
 | shravan on Toad for Oracle keep prompting… |
 | Equinoxio2k on hackertest.net level 1 –… |
 | MH Moni on VB6 on Vista, Error accessing … |
 | ENoiD on DotA Heroes Pool |
 | yash on Generate Insert Statement Scri… |
 | zvit on Toad for Oracle keep prompting… |
Today my first time using Oracle Fine-Grained Auditing. Why do I need to use Oracle Fine-Grained Auditing? This is because there is a table that is accessed by many procedures, triggers and packages. So that in case of deletion, I can not track from which the “DELETE” order came from. I’ve tried using a trigger [...]
Filed under: Oracle | Tagged: Oracle Procedure, Oracle SQL, oracle table, Oracle Trigger | Leave a Comment »
To exit from function is easy, just put “RETURN” CREATE OR REPLACE FUNCTION MIS.FC_GET_ACCRUAL_COM(VAGR IN VARCHAR2) RETURN NUMBER IS VNUM NUMBER; BEGIN SELECT AGR INTO VNUM FROM TAGR WHERE AGR = ‘AA’; IF VNUM = 0 THEN RETURN 1; ELSE RETURN 2; END IF; RETURN VNUM; EXCEPTION WHEN OTHERS THEN RETURN 0; END; / To [...]
Filed under: Oracle | Tagged: Oracle Function, Oracle Procedure, Oracle SQL | Leave a Comment »
 |
 |
|
pandazen
