Advertisement
Guest User

Untitled

a guest
May 16th, 2017
574
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.63 KB | None | 0 0
  1. --같은사용자가 재 설문조사를할경우 Init해주는 쿼리(시작하기전에 한번 실행)
  2. UPDATE MBER_TQ
  3. SET DEL_FLAG = 'Y'
  4. WHERE MBER_EMAIL = '1@gmail.com';
  5.  
  6.  
  7. --답변을 선택할때마다 동적으로 실행되는 인서트쿼리
  8. INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'97@gmail.com' ,1,2,'N');
  9. INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'98@gmail.com' ,1,1,'N');
  10. INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'99@gmail.com' ,1,3,'N');
  11. INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'100@gmail.com' ,1,4,'N');
  12. INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'101@gmail.com' ,1,2,'N');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement