Skip to content

Instantly share code, notes, and snippets.

View lzfelix's full-sized avatar

Luiz Felix lzfelix

View GitHub Profile
insert into departamento(DNOME, DNUMERO, GERSSN, GERDATAINICIO) values
('Pesquisa', 5, null, '1988-05-22'),
('Administração', 4, null, '1995-01-01'),
('Sede administrativa', 1, null, '1981-06-19');
insert into empregado(PNOME, MINICIAL, UNOME, SSN, DATANASC, ENDERECO, SEXO, SALARIO, SUPERSSN, DNO) values
('James', 'E', 'Borg', 888665555, '1937-11-10', '450 Stone, Houston, TX', 'M', 55000, null, 4),
('Franklin', 'T', 'Wong', 333445555, '1955-12-08', '638 Voss, Houston, TX', 'M', 40000, 888665555, 5),
('John', 'B', 'Smith', 123456789, '1965-01-09', '731 Fondren, Houston, TX', 'M', 30000, 333445555, 5),
('Jennifer', 'S', 'Wallace', 987654321, '1941-06-20', '291 Berry, Houston, TX', 'F', 43000, 888665555, 4),
CREATE TABLE DEPARTAMENTO (
DNUMERO INTEGER NOT NULL,
DNOME VARCHAR(20) NULL,
GERDATAINICIO DATE NULL,
GERSSN INTEGER NULL
);
ALTER TABLE DEPARTAMENTO