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