/
romanchel1s
/
sql-translator
Обзор
Документация
Войти
/
romanchel1s
/
sql-translator
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
backend/cases/case06.sql
28 строк
853 B
Roman Purtov
innit
01 сен 2024, 11:27
01 сен 2024, 11:27
58a1772
Код
Авторство
О чём код?
create sequence simple_employees_seq; create table SIMPLE_EMPLOYEES ( empno number primary key, name varchar2(50) not null, job varchar2(50) ); create or replace trigger SIMPLE_EMPLOYEES_BIU_TRIG before insert or update on SIMPLE_EMPLOYEES for each row begin if inserting and :new.empno is null then :new.empno := simple_employees_seq.nextval; end if; end; / insert into simple_employees (name, job) values ('Mike', 'Programmer'); insert into simple_employees (name, job) values ('Taj', 'Analyst'); insert into simple_employees (name, job) values ('Jill', 'Finance'); insert into simple_employees (name, job) values ('Fred', 'Facilities'); insert into simple_employees (name, job) values ('Sabra', 'Programmer'); commit; select empno, name, job from simple_employees order by 1;