Tag: oracle
-
Session 4: Working with Data Main Topics Covered: AND: Both conditions must be true. OR: At least one condition must be true. NOT: Reverses the condition (true → false, false → true). Used to select specific rows based on conditions. Can use comparison operators (=, !=, >, <, >=, <=).…
-
Session 3: Working with Data – Part 1 Selecting & Retrieving Data SELECT Statements The SELECT statement is used to retrieve data from a database. Basic Syntax: SELECT column_name FROM table_name; Example: Selecting student names and IDs from a students table: SELECT student_id, name FROM students; To select all columns,…