Advertisement
Guest User

Untitled

a guest
Jan 16th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. CREATE TABLE Konta
  2. (
  3. nr_tran NUMBER CONSTRAINT kon_pk PRIMARY KEY,
  4. kot NUMBER CONSTRAINT kon_fk_k REFERENCES Elity(id_kota_elity),
  5. data_wprowadzenia DATE,
  6. data_usuniecia DATE,
  7. CONSTRAINT kon_dw CHECK(data_wprowadzenia IS NOT NULL),
  8. CONSTRAINT kon_du CHECK(data_wprowadzenia <= data_usuniecia)
  9. );
  10.  
  11. CREATE OR REPLACE VIEW KontaP OF KONTO_TYPE
  12. WITH OBJECT IDENTIFIER (nr_tran) AS
  13. SELECT nr_tran,
  14. MAKE_REF(ElityP, kot) kot,
  15. data_wprowadzenia,
  16. data_usuniecia
  17. FROM Konta;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement