First let’s understand what DUMP function do in Oracle.
The DUMP function shows the datatype, length in bytes and the actual [...]
Entries Tagged as 'SQL and PL/SQL'
Understanding Internal DATE Storage
December 11th, 2006 · 4 Comments
Tags: SQL and PL/SQL
deleting duplicate rows from a table
December 5th, 2006 · 5 Comments
One of the old way in which I normally do this by using GROUP BY and HAVING keywords.
Example:
DELETE FROM EMP
WHERE [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
Coalesce Function
September 9th, 2006 · No Comments
Today I just come across coalesce function.
In Oracle/PLSQL, the coalesce function returns the first non-null expression in the list. If [...]
Tags: SQL and PL/SQL