본문 바로가기

developer/sql9

오라클 XE 에서 HR계정 활성화시키는 방법 http://mainia.tistory.com/2663 2016. 7. 4.
MS-SQL DATETIME 형변환(CONVERT) MS-SQL 2000에서 날짜 데이터를 문자열로 형변환시 입력 Parameter 별 출력형식입니다. 전에 이거 한참을 찾았던 기억이 나네요.ㅡㅡ; 번호 출력값 사용방법 0 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) 1 02/22/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 2 06.02.22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 3 22/02/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 4 22.02.06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 5 22-02-06 CONVERT(CHAR(8), CURRENT_TIMESTA.. 2015. 4. 3.
Oracle START WITH ~ CONNECT BY 절 MSSQL로 처리하기 * Oracle START WITH ~ CONNECT BY 절 MSSQL로 처리하기. # Oracle SELECT LEVEL, CATE_ID, LTRIM (SYS_CONNECT_BY_PATH (CATE_NAME, ' > '), ' > ') || ' > ' AS CATE_NAME FROM TBL_CATEGORY START WITH CATE_ID = 1 CONNECT BY PRIOR CATE_ID = PARENT_CATE_ID # SQL Server WITH CTE_TABLE AS ( SELECT 1 AS LEVEL, A.CATE_ID, PARENT_CATE_ID, CATE_NAME, CONVERT(VARCHAR(100), CAST(A.CATE_NAME as VARCHAR(100)) + ' > ') AS C.. 2015. 4. 2.
오라클과 MSSQL의 데이터타입 매칭 목록 Data Type ConversionThe gateway converts Microsoft SQL Server data types to Oracle data types as follows:Table A-1 Data Type ConversionsMicrosoft SQL ServerOracleCommentBIGINTNUMBER(19)BINARYRAW-BITNUMBER(3)-CHARCHAR-DATETIMEDATEFractional parts of a second are truncatedDECIMALNUMBER(p[,s])-FLOATFLOAT(49)-IMAGELONG RAW-INTEGERNUMBER(10)NUMBER range is -2,147,483,647 to 2,147,483,647MONEYNUMBER(1.. 2015. 3. 23.

티스토리툴바