ORACLE INVISIBLE Column can be used for column ordering

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 Reorder Email next to NAME. ALTER... Read more

How to find ORACLE locked Objects?

Read more

JSON_TABLE

Referred from Oracle Standard Document Data retrievable / parsing using JSON_TABLE Read more

3 ways to find second highest salary ORACLE SQL

Solution 1 : OR Solution 2 : Solution 3 : Read more

10 ways get Distinct/Unique record without using DISTINCT Oracle

How to get Distinct/Unique record without using DISTINCT SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : Solution 4 : Solution 5 : Solution 6 : Solution 7 : Solution 8 : Solution 9 : Solution 10 : Read more

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 to translate the messages or string returned from PL/SQL stored... Read more

Oracle NULL-Related Functions

Oracle NULL-Related Functions. There are different type of null related function in oracle. Read more

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 some value then always return the first value. Note:= NVL... Read more

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 has the functionality of an IF-THEN-ELSE statement: SELECT DECODE (1,... Read more

Coalesce in oracle

COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER... Read more