declare
v_last_name employees.last_name%type;
v_hire_date employees.hire_date%type;
begin
select user, sysdate
into v_last_name, v_hire_date
from dual;
insert into employees
(
employee_id,
first_name,
last_name,
email,
hire_date,
job_id
)
values
(
seq_employee_id.nextval,
'Test',
v_last_name,
'[email protected]',
v_hire_date,
'IT_PROG'
);
end;
select * from employees where job_id like '%IT%';
insert into employees
(
employee_id,
first_name,
last_name,
email,
hire_date,
job_id
)
values
(
seq_employee_id.nextVal,
'Nurhak',
'KAYA',
'[email protected]',
sysdate,
'IT_PROG'
);
Comments
Post a Comment