Reading Time: 1 minutesSQL Optimizer Hints - Quick tips and description on frequently used SQL Hints: SQL Optimizer Hints /*+ ALL_ROWS */: The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a […]
Oracle
SQL Tuning Tips
Reading Time: 2 minutesSQL Tuning Tips SQL Tuning Tips Quick tips for SQL tuning tips: Do not modify indexed columns with functions such as RTRIM, TO_CHAR, UPPER, TRUNC as this will prevent the […]
SQL Tips & Tricks
Reading Time: 1 minutesSQL Tips & Tricks SQL Tips & Tricks Below are few details which will add value to your SQL knowledge. Count(*) vs Count(1) COUNT(SomeColumn) will only return the count of […]
Oracle/SQL: Slicing a string till nth instance of a particular substring
Reading Time: 2 minutesSlicing a string till nth instance of a particular substring in Oracle Slicing a string till nth instance of a particular substring in Oracle How to slice a string up […]
Microsoft Excel: Using the CONCATENATE function in Microsoft Excel
Reading Time: 1 minutesUsing the CONCATENATE function in Microsoft Excel Using the CONCATENATE function in Microsoft Excel Today, I had a task of building SQL insert queries from an Excel sheet. The Excel […]
Oracle/SQL: Calculating sizes of different tablespaces in an Oracle database
Reading Time: 1 minutesCalculating sizes of different tablespaces in Oracle Calculating sizes of different tablespaces in Oracle: