skymong9.egloos.com

Activation...

포토로그



오라클과 MSSQL의 데이터타입 매칭 목록

Data Type Conversion

The gateway converts Microsoft SQL Server data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Microsoft SQL ServerOracleComment
BIGINTNUMBER(19)
BINARYRAW-
BITNUMBER(3)-
CHARCHAR-
DATETIMEDATEFractional parts of a second are truncated
DECIMALNUMBER(p[,s])-
FLOATFLOAT(49)-
IMAGELONG RAW-
INTEGERNUMBER(10)NUMBER range is -2,147,483,647 to 2,147,483,647
MONEYNUMBER(19,4)-
NCHARNCHAR-
NTEXTLONG-
NVARCHARNCHAR-
NUMERICNUMBER(p[,s])-
REALFLOAT(23)-
SMALL DATETIMEDATEThe value for seconds is returned as 0
SMALL MONEYNUMBER(10,4)-
SMALLINTNUMBER(5)NUMBER range is -32,767 to 32,767
TEXTLONG-
TIMESTAMPRAW-
TINYINTNUMBER(3)-
UNIQUEIDENTIFIERCHAR(36)
VARBINARYRAW-
VARCHARVARCHAR2-

덧글

댓글 입력 영역