/
romanchel1s
/
sql-translator
Обзор
Документация
Войти
/
romanchel1s
/
sql-translator
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
backend/cases/case01.sql
32 строки
1 KB
Roman Purtov
innit
01 сен 2024, 11:27
01 сен 2024, 11:27
58a1772
Код
Авторство
О чём код?
CREATE TABLE employees ( employee_id NUMBER(6) PRIMARY KEY, first_name VARCHAR2(50), last_name VARCHAR2(50) NOT NULL, email VARCHAR2(100) UNIQUE, phone_number VARCHAR2(20), hire_date DATE DEFAULT SYSDATE NOT NULL, job_id VARCHAR2(10) NOT NULL, salary NUMBER(8,2), commission_pct NUMBER(2,2), department_id NUMBER(4), manager_id NUMBER(6) ); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, department_id, manager_id) VALUES (1001, 'John', 'Doe', 'jdoe@example.com', '1234567890', TO_DATE('2023-01-01', 'YYYY-MM-DD'), 'IT_PROG', 6000, NULL, 10, 101); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, department_id, manager_id) VALUES (1002, 'Jane', 'Smith', 'jsmith@example.com', '0987654321', TO_DATE('2023-02-15', 'YYYY-MM-DD'), 'SA_REP', 4500, 0.1, 30, 102); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, department_id, manager_id) VALUES (1003, 'Alice', 'Johnson', 'ajohnson@example.com', '1122334455', TO_DATE('2023-03-10', 'YYYY-MM-DD'), 'HR_REP', 5000, NULL, 20, 103); SELECT NVL(salary, 0) AS salary, DECODE(department_id, 10, 'Accounting', 20, 'Research', 30, 'Sales', 'Other') AS department_name FROM employees;