daily pastebin goal
1%
SHARE
TWEET

Untitled

a guest May 16th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE STYPENDIUM(
  2.   ID_STYP NUMBER(4) NOT NULL,
  3.   ID_STUDENT NUMBER(4),
  4.   KWOTA NUMBER(6,2) NOT NULL,
  5.   DATA_PRZYZ DATE,
  6.   DATA_ZAK DATE,
  7.   CONSTRAINT FK_STUDENT FOREIGN KEY (ID_STUDENT)
  8.   REFERENCES STUDENT(ID)
  9. );
  10.  
  11. INSERT INTO STYPENDIUM VALUES(1, 10, 400, '17/10/09', '18/02/01');
  12. INSERT INTO STYPENDIUM VALUES(2, 20, 350, '17/01/12', '17/10/31');
  13. INSERT INTO STYPENDIUM VALUES(3, 30, 100, '17/01/02', '18/01/01');
  14. INSERT INTO STYPENDIUM VALUES(4, 4, 200, '16/02/01', '17/10/01');
  15. INSERT INTO STYPENDIUM VALUES(5, 8, 200, '17/10/01', '18/01/31');
  16. INSERT INTO STYPENDIUM VALUES(6, 5, 350, '17/10/01', '18/06/30');
  17. INSERT INTO STYPENDIUM VALUES(7, 23, 300, '16/10/01', '17/10/01');
  18. INSERT INTO STYPENDIUM VALUES(8, 21, 100, '18/02/01', '18/06/30');
  19. INSERT INTO STYPENDIUM VALUES(9, 19, 100, '17/02/01', '17/06/30');
  20. INSERT INTO STYPENDIUM VALUES(10, 20, 400, '17/10/01', '18/02/28');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top