CREATE TABLE TB_VENDEDORESTS
(
Matricula VARCHAR2(5),
Nome VARCHAR2(100),
Data_admissao DATE,
Percentual_comissao NUMBER(5,3)
)
INSERT INTO TB_VENDEDORESTS
(Matricula, Nome, Data_admissao, Percentual_Comissao)
VALUES
('00233','João Geraldo da Fonseca','01/12/2015','0,10');
INSERT INTO TB_VENDEDORESTS
(Matricula, Nome, Data_admissao, Percentual_Comissao)
VALUES
('00400','Maria do Rosario','23/07/2012','0,15');
INSERT INTO TB_VENDEDORESTS
(Matricula, Nome, Data_admissao, Percentual_Comissao)
VALUES
('00810','Marcia Almeida','14/12/2016','0,18');
INSERT INTO TB_VENDEDORESTS
(Matricula, Nome, Data_admissao, Percentual_Comissao)
VALUES
('00414','Carlos Moreira','13/11/2015','0,14');
INSERT INTO TB_VENDEDORESTS
(Matricula, Nome, Data_admissao, Percentual_Comissao)
VALUES
('00934','Juvenildo Martins','09/03/2010','0,20');
SELECT * FROM TB_VENDEDORESTS