Monthly Archives: August 2011

Oracle range limit AD BC dates

This is the extreme limit for oracle dates: alter session set nls_date_format = ‘Dy DD-Mon-YYYY AD’ ; select sysdate, to_date(’01-JAN-4712 BC’,’DD-MON-YYYY AD’), to_date(’30-DEC-9999 AD’,’DD-MON-YYYY AD’) from dual ; Without encountering this error: ORA-01841: (full) year must be between -4713 and

Posted in Uncategorized

Oracle SQL Developer privileges for Other Users procedures and package bodies

To view code for procedures and package bodies in SQL Developer that are owned by other users, you need the following privilege: grant select_catalog_role to <user> ; This privilege does not give access to the$ view, so should be

Posted in SQL Developer

Oracle Data Guard Overview

Oracle Data Guard is Oracle’s main solution for high¬†availability¬†in the event of a disaster. This overview is for Oracle 11gR2. A pdf version of this page is available here.

Posted in Dataguard

Switch Oracle Forms List of Values on and off dynamically at run time

In e.g. post-query block level trigger: IF block.check_field = ‘F’ THEN — switch on Set_Item_Property( ‘block.field’ , LOV_NAME, ‘your lov’) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_TRUE); ELSE — switch off Set_Item_Property( ‘block.field’ , LOV_NAME, ”) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_FALSE); END

Posted in Oracle forms