- •54) Declare
- •52) Declare
- •50) Declare
- •49)Set serveroutput on;
- •48) Set serveroutput on;
- •47) Declare
- •46) Declare
- •45) Declare
- •41) Set serveroutput on;
- •40) Declare
- •42) Set serveroutput on;
- •38) Declare
- •37) Set serveroutput on;
- •36) Set serveroutput on;
- •35) Declare
- •34) Declare
- •33) Declare
- •32) Declare
- •31) Declare
- •16) Решение:Еламан
- •15) Решение:Еламан
50) Declare
salary employees.salary%TYPE;
begin
update employees
set salary =(select (salary*0.3 +salary)from employees where hire_date>22.03.2010 and commission_pct<10;)
where hire_date>22.03.2010 and commission_pct<10; end;
49)Set serveroutput on;
BEGIN
FOR item in (SELECT * FROM hr.employees)
LOOP
DBMS_OUTPUT.PUT_LINE(item.employee_id || ' ' || item.first_name || ' ' || item.last_name);
END LOOP;
END;
48) Set serveroutput on;
declare nAvg number(8,2);
begin
select avg(salary) into nAvg FROM hr.employees;
DBMS_OUTPUT.PUT_LINE (nAvg);
end;
47) Declare
sFirstName varchar2(20) := '&Имя_сотрудника';
sLastName varchar2(25) := '&Фамилия_сотрудника';
sEmail varchar2(25) := '&Адрес_электронной_почты';
sPhoneNumber varchar2(20) := '&Номер_телефона';
sJobId varchar2(10) := '&Должность_сотрудника';
BEGIN
insert into hr.employees values(employees_seq.nextval, sFirstName, sLastName, sEmail, sPhoneNumber, sysdate, sJobId, (SELECT MIN(SALARY) from hr.employees where job_id=sJobId), null,null, null);
commit;
END;
46) Declare
sFirstName employees.first_name%TYPE;
sLastName employees.Last_Name%TYPE;
sEmail employees.email%TYPE;
sPhoneNumber employees.phone_number%TYPE;
sJobId employees.job_id%TYPE;
BEGIN
sFirstName := '&Имя_сотрудника';
sLastName := '&Фамилия_сотрудника';
sEmail := '&Адрес_электронной_почты';
sPhoneNumber := '&Номер_телефона';
sJobId := '&Должность_сотрудника';
insert into hr.employees values(employees_seq.nextval, sFirstName, sLastName, sEmail, sPhoneNumber, sysdate, sJobId, (SELECT MIN(SALARY) from hr.employees where job_id=sJobId), null,null, null);
commit;
END;
45) Declare
sFirstName varchar2(20) := '&Имя_сотрудника';
sLastName varchar2(25) := '&Фамилия_сотрудника';
sEmail varchar2(25) := '&Адрес_электронной_почты';
sPhoneNumber varchar2(20) := '&Номер_телефона';
sJobId varchar2(10) := '&Должность_сотрудника';
BEGIN
insert into hr.employees values(employees_seq.nextval, sFirstName, sLastName, sEmail, sPhoneNumber, sysdate, sJobId, (SELECT MIN(SALARY) from hr.employees where job_id=sJobId), null,null, null);
commit;
END;
44) sFirstName varchar2(20) := '&Имя_сотрудника';
sLastName varchar2(25) := '&Фамилия_сотрудника';
sEmail varchar2(25) := '&Адрес_электронной_почты';
sPhoneNumber varchar2(20) := '&Номер_телефона';
sJobId varchar2(10) := '&Должность_сотрудника';
BEGIN
insert into hr.employees values(employees_seq.nextval, sFirstName, sLastName, sEmail, sPhoneNumber, sysdate, sJobId, (SELECT avg(SALARY) from hr.employees where job_id=sJobId), null,null, null);
commit;
43) sFirstName varchar2(20) := '&Имя_сотрудника';
sLastName varchar2(25) := '&Фамилия_сотрудника';
sEmail varchar2(25) := '&Адрес_электронной_почты';
sPhoneNumber varchar2(20) := '&Номер_телефона';
sJobId varchar2(10) := '&Должность_сотрудника';
BEGIN
insert into hr.employees values(employees_seq.nextval, sFirstName, sLastName, sEmail, sPhoneNumber, sysdate, sJobId, (SELECT max(SALARY) from hr.employees where job_id=sJobId), null,null, null);
commit;