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
Referred from Oracle Standard Document Data retrievable / parsing using JSON_TABLE Read more
Solution 1 : OR Solution 2 : Solution 3 : Read more
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.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. There are different type of null related function in oracle. Read more
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 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 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