Referred from John’s cookbook sample app. Checkboxes are little bit tricky and difficult. I was trying to implement it for long time but it’s bit problematic than i thought. After John Snyders cookbook update for 19.2 things are very easy. I would... Read more
How to save table images to oracle directory? Files from table to Oracle directory How to Send all files in ZIP? You might Like: Read more
Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments... Read more
How to delete duplicate record From table using SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more
How to check duplicate record in table SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more
Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If the first parameter is not null, then it returns the... 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