create table toway
(IDTowary number(5) constraint pktowary primary key,
nazwa varchar2(50) constraint nntowarynazwa not null,
cena number(7,2) constraint chtowatycena check(cena>0))
/


@constr toway


insert into toway
values(1,'kawa',100)
/


insert into toway (IDTowary,cena)
values(2,100)
/


select * from toway
/


create table klienci
(IDKlienta number(5) primary key,
firma varchar2(50) not null,
adres varchar2(40) not null,
platnikVAT char(1) default 'T')
/


create table klienci
(IDKlienta number(5) primary key,
firma varchar2(50) not null,
adres varchar2(40) not null,
platnikVAT char(1) default 'T'),
check(platnikVA in ('t','n'),
unique(firma))
/