기억의 습작

Comparison of A and B data types 본문

DB

Comparison of A and B data types

뿌사리다 2021. 8. 19. 22:33

MSsql 과  Oracle 데이터 타입 비교

Microsoft SQL Server Oracle Comment
BIGINT NUMBER(19)  
BINARY RAW -
BIT NUMBER(3) -
CHAR CHAR -
DATETIME DATE Fractional parts of a second are truncated
DECIMAL NUMBER(p[,s]) -
FLOAT FLOAT(49) -
IMAGE LONG RAW -
INTEGER NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647
MONEY NUMBER(19,4) -
NCHAR NCHAR -
NTEXT LONG -
NVARCHAR NCHAR -
NUMERIC NUMBER(p[,s]) -
REAL FLOAT(23) -
SMALL DATETIME DATE The value for seconds is returned as 0
SMALL MONEY NUMBER(10,4) -
SMALLINT NUMBER(5) NUMBER range is -32,767 to 32,767
TEXT LONG -
TIMESTAMP RAW -
TINYINT NUMBER(3) -
UNIQUEIDENTIFIER CHAR(36)  
VARBINARY RAW -
VARCHAR VARCHAR2 -

출처: https://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm#i634210

728x90
반응형
LIST

'DB' 카테고리의 다른 글

Hibernate dialect  (0) 2021.08.29
JSP에서 DB쿼리문 실행기 제작  (0) 2021.08.28
DB시퀀스 (DB Sequence)  (0) 2021.08.19
DB sequence size  (0) 2021.08.19
db sequence가 이상할때 고려해야할 점.  (0) 2021.08.19