| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 06:15:07 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=360ace7230b9153374087f861eae8d50f4fd67644ba253ca1d434b50ccafcbf3a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22T8DL9yUElfIuxegmef4DN4A2FBCXtxN4%22%3B%7D; HttpOnly; Path=/
cf-ray: 98cc389e6e62a403-BLR
Atividade - Trigger - Oracle - Pastebin.com
SHARE
TWEET
Atividade - Trigger - Oracle
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---- SETORES -----
- CREATE SEQUENCE SETOR_ID;
- CREATE TABLE setores (
- id NUMBER DEFAULT SETOR_ID.NEXTVAL PRIMARY KEY,
- setor VARCHAR2(200),
- total_funcionarios NUMBER DEFAULT(0)
- );
- INSERT INTO setores (setor) VALUES ('RH');
- INSERT INTO setores (setor) VALUES ('Financeiro');
- INSERT INTO setores (setor) VALUES ('Acadêmico');
- INSERT INTO setores (setor) VALUES ('Reitoria');
- INSERT INTO setores (setor) VALUES ('Almoxarifado');
- ------- EMPREGADOS -------
- CREATE SEQUENCE EMPREGADO_ID;
- CREATE TABLE empregados (
- id NUMBER DEFAULT EMPREGADO_ID.NEXTVAL PRIMARY KEY,
- nome VARCHAR2(200),
- salario NUMBER,
- setor_id NUMBER references setores(id)
- );
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Arthur', 2314.50, 1);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Alice', 3000.00, 1);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Sophia', 1500.00, 2);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Júlia', 2000.00, 2);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Pedro', 1000.50, 3);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Antonio', 1888.90, 3);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Marcos', 5000.00, 4);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Lais', 3450.30, 4);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Monica', 3333.33, 5);
- INSERT INTO empregados (nome, salario, setor_id) VALUES ('Eduardo', 1543.00, 5);
- ------ LOGS --------
- CREATE TABLE logs_empregados (
- empregado_id NUMBER,
- usuario VARCHAR2(200),
- operacao VARCHAR2(200),
- data_operacao TIMESTAMP
- );
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐✅ Trading Profit Method ✅ NEVER SEEN BEFORE...
JavaScript | 4 sec ago | 0.24 KB
-
⭐ Instant BTC Profit Method ✅ NEVER SEEN BEFO...
JavaScript | 13 sec ago | 0.24 KB
-
⭐✅ MAKE $2000 INSTANTLY ✅ NEVER SEEN BEFORE ⭐...
JavaScript | 23 sec ago | 0.24 KB
-
⭐ Free Crypto Method ✅ NEVER SEEN BEFORE ⭐⭐⭐
JavaScript | 34 sec ago | 0.24 KB
-
✅⭐ Make huge profits on trading ✅ NEVER SEEN...
JavaScript | 45 sec ago | 0.24 KB
-
⭐✅ Marketplace Glitch ✅ Working ✅ NEVER SEEN...
JavaScript | 54 sec ago | 0.24 KB
-
✅⭐ Make $2500 in 15 minutes ✅ NEVER SEEN BEFO...
JavaScript | 1 min ago | 0.24 KB
-
⭐ Instant BTC Profit Method ✅ NEVER SEEN BEFO...
JavaScript | 1 min ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
