SQLize | PHPize | SQLtest

CREATE TABLE employees ( employee_id NUMBER PRIMARY KEY, full_name VARCHAR2(50) NOT NULL, department VARCHAR2(30) NOT NULL, salary NUMBER DEFAULT 0 CHECK (salary >= 0), commission NUMBER, hire_date DATE DEFAULT SYSDATE, status VARCHAR2(15) CHECK (status IN ('Active', 'Resigned', 'On Leave')) ); INSERT INTO employees VALUES (1, 'Momen Khaled', 'IT', 5000, 500, DATE('2022-01-15', 'YYYY-MM-DD'), 'Active'); INSERT INTO employees VALUES (2, 'Fatema Ahmed', 'HR', 4000, NULL, DATE('2021-11-10', 'YYYY-MM-DD'), 'On Leave'); INSERT INTO employees VALUES (3, 'Salma Youssef', 'Marketing', 4500, 300,DATE('2020-05-23', 'YYYY-MM-DD'), 'Active'); INSERT INTO employees VALUES (4, 'Khaled Tamer', 'Sales', 3800, 200, DATE('2019-03-12', 'YYYY-MM-DD'), 'Resigned'); INSERT INTO employees VALUES (5, 'Omar Nasser', 'IT', 5200, NULL, DATE('2023-02-01', 'YYYY-MM-DD'), 'Active'); INSERT INTO employees VALUES (6, 'Reem Adel', 'Finance', 4700, 150, DATE('2018-07-30', 'YYYY-MM-DD'), 'On Leave');