Inserting Data

Syntax: To insert new records into a table:

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

Example

INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary) VALUES (1, 'John', 'Doe', SYSDATE, 50000);

Bulk Insert: Multiple rows can be inserted at once:

INSERT ALL 
    INTO employees (employee_id, first_name, last_name) VALUES (2, 'Jane', 'Smith')
    INTO employees (employee_id, first_name, last_name) VALUES (3, 'Alice', 'Johnson')
SELECT * FROM dual;