shit

create table MY_EMPLOYEE ( id INTEGER ,
                           last_name VARCHAR(30),
                           first_name VARCHAR(30),
                           USERID VARCHAR(20),
                           Salary INTEGER);
select * from my_employee;
insert into my_employee
values(1,'Patel','Ralph','rpatel',795);
insert into my_employee
values(2,'Dancs','Betty','bdancs',860);
insert into my_employee
values(3,'Biri','Ben','bbiri',1100);
insert into my_employee
values(4,'Newman','Chad','cnewman',750);
insert into my_employee
values(5,'Ropeburn','Audry','aropebur',1550);

accept id prompt 'Introduceti id: '
accept last_name prompt 'Introduceti numele: '
accept first_name prompt 'Introduceti prenumele: '
accept userid prompt 'Introduceti user id: '
accept salary prompt 'Introduceti salariul: '
insert into my_employee
values (&id,'&last_name','&first_name','&userid',&salary);

select * from my_employee;

delete  from my_employee
where last_name=null;


update my_employee
SET salary=1200
where salary<1000;

update my_employee
set last_name='Drexler'
where id=3;

delete from my_employee
where first_name='Betty';

update... savepoint update_done;