Posts in: Databases
Arithmetic & Aliases
Perform calculations in SELECT and rename columns using aliases for better readability.
Read More →Filtering & Expressions
Learn various filtering techniques and expressions used to extract specific data from Oracle SQL tables.
Read More →IN, NOT IN, BETWEEN, LIKE
Learn how to use IN, NOT IN, BETWEEN, and LIKE to filter rows with flexible matching logic, especially useful for text search, ranges, and list matching.
Read More →IS NULL vs = NULL
Understand the difference between IS NULL and = NULL in SQL and avoid common mistakes while filtering NULL values.
Read More →