Facebook
From Tinct Crane, 8 Years ago, written in Oracle 9.2 PL/SQL.
This paste is a reply to Re: Re: Untitled from Sexy Camel - view diff
Embed
Download Paste or View Raw
Hits: 582
  1. CREATE TABLE PozycjeDokumentu
  2.   (
  3.     ID           NUMBER (10) NOT NULL ,
  4.     Lp           NUMBER (3) NOT NULL ,
  5.     Cena         NUMBER (12,2) NOT NULL ,
  6.     Ilosc        NUMBER NOT NULL ,
  7.     Rabat        NUMBER (8,6) ,
  8.     SumaNetto    NUMBER (12,2) NOT NULL ,
  9.     SumaVAT      NUMBER (12,2) NOT NULL ,
  10.     SumaBrutto   NUMBER (12,2) NOT NULL ,
  11.     MasaNetto    NUMBER ,
  12.     MasaBrutto   NUMBER ,
  13.     Dokument     NUMBER (10) NOT NULL ,
  14.     Towary       NUMBER (10) NOT NULL ,
  15.     PartiaTowaru NUMBER (10) ,
  16.     Magazyn      NUMBER (10) NOT NULL ,
  17.     KierunekMagazynu      NUMBER (1) NOT NULL ,
  18.     HandlowyMagazynowy CHAR (1) NOT NULL
  19.   ) ;
  20. ALTER TABLE PozycjeDokumentu ADD CONSTRAINT PozycjeDokumentu_PK PRIMARY KEY ( ID ) ;
  21. ALTER TABLE PozycjeDokumentu ADD CONSTRAINT HanMag_CK CHECK ( HandlowyMagazynowy IN ( 'H', 'M')) ;

Replies to Re: Re: Re: Untitled rss

Title Name Language When
Re: Re: Re: Re: Untitled Blush Lion plsql 8 Years ago.
Re: Re: Re: Re: Untitled Ample Penguin plsql 8 Years ago.