Notice
Recent Posts
Recent Comments
목록개발/PostgreSQL (1)
SNOWFLAKES DRAWING PAPER
Merge문 변환 (Oracle To PostgreSQL)
:: ORACLE ::MERGE INTO CC_TC_USER_MUSING DUAL ON ( USER_ID='USER_ID' )WHEN MATCHED THENUPDATE SET USER_ID='USER_ID', USER_NM='USER_NM', USER_PWD='USER_PWD'WHEN NOT MATCHED THENINSERT ( USER_ID,USER_NM,USER_PWD )VALUES ( 'USER_ID','USER_NM','USER_PWD' ) :: POSTGRESQL ::WITH UPSERT AS ( SELECT 'USER_ID' AS USER_ID, 'USER_NM' AS USER_NM, 'USER_PWD' AS USER_PWD),UPDATE_OPTION AS ( UPDATE CC_TC_USER_..
개발/PostgreSQL
2016. 6. 15. 17:27