본문 바로가기

새로운생각/SQL3

[iBatis] 주요 태그 Tag 1] Alias 2] 기본 태그 Select : Insert : Update: Delete : Statement : 3] 프로퍼티 존재여부 존재할때 : 존재하지 않을때 : 4] 프로퍼티 Null 체크 Null 일때 : Null 아닐때 : 5] 프로퍼티 Empty 체크 Empty 일때 : Empty 아닐때 : 6] 프로퍼티 값비교 같을때 : 같지 않을때 : 7] ParameterMap 8] ResultMap 9] Dynamic select a from test id = #a# name = #b# no = #c# no_as = #d# 출처 : http://egloos.zum.com/happy2ni/v/9609765 2016. 11. 30.
[ORACLE] View Oracle Table and Column information --COLUMN INFORMATION FOR TABLE SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE , DATA_LENGTH , DATA_PRESICION , DATA_SCALE , NULLABLE , COLUMN_ID , DATA_DEFAULT , CHAR_LENGTHFROM USER_TAB_COLUMNSWHERE TABLE_NAME = 'TABLE_NAME' --FIELD COMENT SELECT COLUMN_NAME , COMMENTSFROM USER_COL_COMMENTSWHERE TABLE_NAME='TABLE_NAME' --COLUMN INFORMATION FOR TABLE SELECT A.COLUMN_ID , B.COMMENTS , A.COLUMN_NAME .. 2016. 11. 30.
[ORACLE] MERGE INTO INSERT AND UPDATE Method of use ORACLE MERGE INTO Method of use *merge into method, it is available starting with Oracle9 MERGER INTO TABLE_NAME AUSING TABLE_NAME/VIEW/SELECT statementON (JOIN Condition)WHEN MATCHED THENUPDATE SETColumn1 = VALUE1Column2 = VALUE2...WHEN NOT MATHCED THENINSERT (Column1, Column2, ...) VALUES (Value1, Value2, ...); MERGE INTO TEST1 AUSING (SELECT SEQ FROM TEST2) BON (A.SEQ = B.SEQ)WHEN MATCHED THE.. 2016. 11. 24.

티스토리툴바