Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --같은사용자가 재 설문조사를할경우 Init해주는 쿼리(시작하기전에 한번 실행)
- UPDATE MBER_TQ
- SET DEL_FLAG = 'Y'
- WHERE MBER_EMAIL = '1@gmail.com';
- --답변을 선택할때마다 동적으로 실행되는 인서트쿼리
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'97@gmail.com' ,1,2,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'98@gmail.com' ,1,1,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'99@gmail.com' ,1,3,'N');
- INSERT INTO MBER_TQ VALUES(SEQ_MBER_TQ_IDX.NEXTVAL ,'100@gmail.com' ,1,4,'N');
- 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