Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Konta
- (
- nr_tran NUMBER CONSTRAINT kon_pk PRIMARY KEY,
- kot NUMBER CONSTRAINT kon_fk_k REFERENCES Elity(id_kota_elity),
- data_wprowadzenia DATE,
- data_usuniecia DATE,
- CONSTRAINT kon_dw CHECK(data_wprowadzenia IS NOT NULL),
- CONSTRAINT kon_du CHECK(data_wprowadzenia <= data_usuniecia)
- );
- CREATE OR REPLACE VIEW KontaP OF KONTO_TYPE
- WITH OBJECT IDENTIFIER (nr_tran) AS
- SELECT nr_tran,
- MAKE_REF(ElityP, kot) kot,
- data_wprowadzenia,
- data_usuniecia
- FROM Konta;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement