CREATE TABLE TMP_ROLE_PAYMENT_SEARCH( ROLE_NAME VARCHAR(50) ) INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPGD') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDDV') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PGD') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PTGD') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TGD') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('HDQT') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TP') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PP') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TBP') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KTT') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDK') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KSV') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TC') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('NVTC') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPTC') INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PPGD') SELECT * FROM TMP_ROLE_PAYMENT_SEARCH