How to find ORACLE locked Objects?

Copy CodeCopiedUse a different BrowserSELECT a.osuser, a.sid, b.os_user_name, b.oracle_username, b.session_id, c.object_name, c.object_type FROM v$session a, v$locked_object b, dba_objects c WHERE a.sid = b.session_id AND b.object_id = c.object_id AND c.object_name =…

JSON_TABLE

Referred from Oracle Standard Document Data retrievable / parsing using JSON_TABLE Copy CodeCopiedUse a different BrowserSELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED…

APEX_LANG

APEX_LANG.MESSAGE API is a great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very useful…

Oracle NULL-Related Functions

Oracle NULL-Related Functions. There are different type of null related function in oracle. NVL NVL function will check whether the first input parameter is null, if its null value, it…

Oracle NVL Function

The NVL function allows you to replace null values with a default values. If the first parameter is null, the function returns the second parameter. If the first parameter has…

Oracle Decode Function

Oracle DECODE() function compares the first argument with the second argument. If they are equal, the function returns the third argument otherwise returns the default value. The Oracle/PLSQL DECODE function…