3 ways to remove duplicate data
Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]
Read more
Category: ORACLE
NOT IN and NULL: a dangerous combination
Non-correlated subqueries (where the inner query does not have any column from the outer query tables) are usually implemented using[…]
Read more
Using SQL in Python
Python has become one of the most popular programming languages and is used in various contexts, including in WEB applications[…]
Read more
LEAD and LAG: accessing multiple rows without self join
LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]
Read more
Coalesce, NVL, ISNULL, Case, … What should a I use?
There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]
Read more
Looking for missing values using recursive queries
In most of application databases, we can find one or more numeric columns representing IDs or used as primary keys.[…]
Read more
Sending Mail in Oracle with UTL_SMTP
Let’s take a look on how to send mail in Oracle DBMS using the UTL_SMTP package in a step-by-step basis:[…]
Read more
Are ROWNUM and ROWID the same column?
No. In Oracle DBMS, ROWNUM and ROWID are pseudocolumns that can be accessed in SQL queries, but they aren’t the[…]
Read more
Using a recursive query to create a list of dates
In enterprise database systems, one may commonly find business events (e.g. sales, revenue, etc) associated to dates or months. In[…]
Read more
Database Users and Schemas – concepts and tricks
There is some confusion when dealing with some users and schemas. Some DBMS support several schemas per database, while other[…]
Read more