Tabela SQL

Seite 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