심플한 홍로그

정렬 사용 전 Ctrl + F7 Click!

INSERT INTO member_info (mi_num,mi_user_id,mi_part_id,mi_delyn,mi_cre_date) SELECT'115164','12','12','N','20170123011011'FROMdualWHERE1 = 1AND NOTEXISTS ( SELECT mi_num, mi_user_id FROM member_info WHERE 1 = 1 AND mi_num = '115164' AND mi_user_id = '12');

쿼리 입력창에 입력하시면 됩니다. select TABLE_NAME, COLUMN_NAMEfrom ALL_TAB_COLUMNSwhere COLUMN_NAME LIKE '%컬럼이름%';