ORACLE TECHNOLOGY

Usually when we use the filter table in adf  , some time it will not work and when you use the new criteria it display result of existing filter criteria so call the following method to work filters in your page use the following method to work your filters proper   public void resetPerfectedTableFilter()         {      FilterableQueryDescriptor queryDescriptor =  (FilterableQueryDescriptor) getPerfectedCaseTable().getFilterModel();             if (queryDescriptor != null &&  queryDescriptor.getFilterCriteria() != null)             {    queryDescriptor.getFilterCriteria().clear();                 getPerfectedCaseTable().queueEvent(new QueryEvent(getPerfectedCaseTable(),                                   ...

CREATE OR REPLACE TRIGGER LOG_AUDIT_TRIGGER AFTER   INSERT OR UPDATE ON DEV2_APP.CASES   --table name on which u want to fire a trigger   REFERENCING OLD AS OLD NEW AS NEW   FOR EACH ROW     --WHEN (new.case_status_code<>old.case_status_code)   DECLARE                                                            -- variable declaration     n_status VARCHAR2(5) ;     o_status varchar2(5);   --n_status_reason varchar2(50) ;   n_modified_date DATE;   n_modified_user VARCHAR2(20);   o_caseId          VARCHAR2(20);   l_changeid      NUMBER; -- curser body or defination   CURSOR c_getmax_changeid(caseid VARCHAR2,field_name VARCHAR2)   IS     SELECT MAX(CA.change_id) AS maxChangeId ...