Oracle count null and not null values in column
In this article we will post two ways of counting
Oracle
SQL union and where clause
Sometimes there is a need of filtering result of a
Nice article about 10 SQL optimisations: MySQL, Oracle, SQL Server, DB2, PostgreSQL
Recently I found a very nice article explaining in great
Oracle refresh statistics on owner/table
Check is it needed update of statistics
If you want
Oracle, MySQL - select max and return multiple values
A common problems in SQL are to find the data
Oracle indexes - create, rebuild, select, drop
Select all indexes by status
Check indexes by status by
SQL concatenate examples
Concatenation basics
*
concatenation functions:
* Oracle - concat
* MySQL - concat