Oracle Decode Function

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 return default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: SELECT DECODE (1, 1, 'ONE', …

Oracle NVL Function

Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value. Note := NVL function replaces null value with same type data. Syntax of the …

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 returns the second parameter value. DECODE The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. * …

Preview an Image Before Upload Oracle APEX

Preview an Image Before Upload Oracle APEX Sometimes we face the requirement like how to show the image before image upload. There are some easy steps to preview images before upload. Create a blank page with two region. One for file browse option and second is sub-region for showing images. Create a Page Item on …