Oracle & SQL Server: COUNT(*) vs. COUNT(1) vs. COUNT(ColumnName) – Differences

NULL's will be eliminated! When doing a count() operation, it helps to understand what is counted and what is not. Count can be done in multiple ways COUNT(*) COUNT(1) COUNT([Column_Name]) COUNT(DISTNCT [Column_Name]) With and without GROUP BY While it is straight-forward to get a count, here are a couple of things to note NULL values … Continue reading Oracle & SQL Server: COUNT(*) vs. COUNT(1) vs. COUNT(ColumnName) – Differences

Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!

If you are primarily a SQL Server developer and you are moving to Oracle, this is one of the nastiest surprises in store for you. You are so used to rolling back everything including DDL in SQL Server transactions but in Oracle, DDL inside transactions act as COMMIT. Fear not though, there are a ton … Continue reading Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!