Oracle SELECT Statement 🔍

Mentor's Note: In Oracle, SELECT is your way of asking the database for information. Every data-driven application in the world starts with a SELECT query. 💡

---

🌟 The Scenario: The Digital HR Office 📂

Imagine you are the HR manager at a tech company. You have a massive filing cabinet (The EMPLOYEES table).

• Goal: You need to pull out a list of all names and their current salaries.
• Action: You "Select" only those two columns and ignore the rest.

---

💻 1. The Basic Syntax

SELECT column1, column2, ...
FROM table_name;

Example: Fetching Employee Names

SELECT first_name, last_name, salary 
FROM employees;

---

🏗️ Architect's Note: Performance & Dual 🛡️

1. Avoid SELECT *: In high-demand Oracle systems, selecting all columns causes unnecessary "Logical Reads" and increases network traffic. Always name your columns!
2. The DUAL Table: Oracle has a special one-row table called DUAL. Use it for testing expressions or system functions.

   SELECT 10 * 5 FROM dual; -- Returns 50
   SELECT sysdate FROM dual; -- Returns current date

---

🎨 Visual Logic: The Filter

---

📈 Learning Path

• Next: ORDER BY →