Advertisement
Guest User

Untitled

a guest
May 1st, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.80 KB | None | 0 0
  1. INSERT INTO GG_CATEGORY_DUP
  2. SELECT * FROM GG_CATEGORY;
  3.  
  4. INSERT INTO GG_COUNTRY_DUP
  5. SELECT * FROM GG_COUNTRY;
  6.  
  7. INSERT INTO GG_DONATION_DUP
  8. SELECT * FROM GG_DONATION;
  9.  
  10. INSERT INTO GG_DONATIONDETAIL_DUP
  11. SELECT * FROM GG_DONATIONDETAIL;
  12.  
  13. INSERT INTO GG_DONATIONOPTION_DUP
  14. SELECT * FROM GG_DONATIONOPTION;
  15.  
  16. INSERT INTO GG_DONOR_DUP
  17. SELECT * FROM GG_DONOR;
  18.  
  19. INSERT INTO GG_ORGANIZATION_DUP
  20. SELECT * FROM GG_ORGANIZATION;
  21.  
  22. INSERT INTO GG_PROJCAT_DUP
  23. SELECT * FROM GG_PROJCAT;
  24.  
  25. INSERT INTO GG_PROJECT_DUP
  26. SELECT * FROM GG_PROJECT;
  27.  
  28. INSERT INTO GG_SHOPPINGCART_DUP
  29. SELECT * FROM GG_SHOPPINGCART;
  30.  
  31. CREATE TABLE GG_SHOPPINGCART_DUP
  32. (
  33.   cart_id INTEGER NOT NULL,
  34.   donor_id INTEGER NOT NULL,
  35.   project_id INTEGER NOT NULL,
  36.   donation_quantity INTEGER NOT NULL,
  37.   donation_amount INTEGER NOT NULL
  38. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement