SQLize Online / PHPize Online  /  SQLtest Online

drop view testv; drop table copye; create table copye as select * from employees; create or replace view testv as select salary, first_name, last_name, email, hire_date, job_id, department_id from copye where department_id = 60; INSERT INTO testv (employee_id, salary, first_name, last_name, email, hire_date, job_id, department_id) VALUES (1000, 10000, 'JAiiCK', 'dddd', 'dsasasa', SYSDATE, 'JOB_ID_', 19); update testv set email = 'lalalalalala' where department_id = 60; delete from testv where last_name = 'Hunold'; select * from testv; select * from copye;