Skip to content

Oracle WHERE Clause 🔍

Prerequisites: SELECT Statement

Mentor's Note: The WHERE clause is the "Filter" of your database. It allows you to pick specific needles from the haystack of data based on rules you define. 💡

🌟 The Scenario: The Targeted Mailing ✉️

  • Goal: You want to send a letter only to employees who earn more than ₹50,000.
  • Action: You tell Oracle: "Show me all people WHERE salary > 50000."

💻 1. The Basic Syntax

SELECT columns
FROM table
WHERE condition;

Example: Finding a specific Employee ID

SELECT first_name, last_name 
FROM employees 
WHERE employee_id = 101;

🏗️ Architect's Note: Indices & Predicates 🛡️

The WHERE clause is where performance is won or lost. - The Secret: If you filter on a column that has an Index, Oracle can find the row instantly (Index Seek). If there is no index, Oracle must read the entire table (Full Table Scan). - Architecture Tip: Always aim to filter by the Primary Key or Unique Keys whenever possible for maximum speed.

📈 Learning Path