How to generate DDL of any object in ORACLE? SELECT DBMS_METADATA.get_ddl ( <OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL;

How to reorder ORACLE table columns? Sample table CREATE TABLE TEST_COLUMN ( ID NUMBER, NAME VARCHAR2(200) CREATED_BY VARCHAR2(50) ); Add a column ALTER TABLE TEST_COLUMN ADD EMAIL VARCHAR2(50); Column Order will be ID NAME CREATED_BY EMAIL Reorder Email next to NAME. ALTER TABLE TEST_COLUMN MODIFY CREATED_BY …

How to find lock Object in ORACLE. SELECT 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 = UPPER ('TABLE_NAME');

JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …

JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …

3 Ways to find second highest salary ORACLE SQL. Solution 1 : WITH T AS ( SELECT SAL,ENAME, DENSE_RANK() OVER (ORDER BY SAL Desc) AS Rnk FROM EMP ) SELECT SAL,ENAME FROM T WHERE Rnk IN (2); --WHERE Rnk IN (1,2,3); OR SELECT ENAME,SAL, RANK FROM( SELECT ENAME,SAL,DENSE_RANK() OVER (ORDER BY SAL DESC) RANK FROM EMP ) …