Notas
Tabela SQL
Conteúdo das notas (1)
Página 1
create table tbl_venda(
id_nf number not null,
id_item number not null,
valor_unit number
(4,2)not null,
quantidade number not null
desconto number
);
insert into tbl_venda values
(1,1,1,25,10,5);
insert into tbl_venda values
(1,2,2,13.50,3,null);
insert into tbl_venda values
(1,3,3,15,2,null);
insert into tbl_venda values
(1,4,4,10,1,null);
insert into tbl_venda values
(1,5,5,30,1,null);
insert into tbl_venda values
(4,1,5,30,10,15);
insert into tbl_venda values
(4,2,4,10,12,5)
insert into tbl_venda values
(4,3,2,25,13,5);
insert into tbl_venda values
(4,4,2,13,50,15,5);
insert into tbl_venda