CUBRID vs MySQL vs ORACLE SQL 타입별 비교

구분

CUBRID

MySQL

Oracle

수치형

-

-

BINARY_FLOAT

BIGINT

BIGINT

-

NUMERIC(20)

DECIMAL

DECIMAL

DECIMAL

DOUBLE

DOUBLE

BINARY_DOUBLE

DOUBLE PRECISION

DOUBLE PRECISION

-

FLOAT

FLOAT

FLOAT

INT

MEDIUMINT

-

INT, INTEGER

SMALLINT

INTEGER

INTEGER

-

MONETARY

-

-

NUMERIC(p, s)

-

NUMBER(p, s)

NUMERIC(38, 0)

-

NUMBER(p,0)

NUMERIC(38, 15)

-

NUMBER

NUMERIC(M,D)

FLOAT(M,D) or REAL(M,D) 

-

REAL

-

-

SHORT

-

-

SMALLINT

BIT(1) (>MySQL-5.0)

-

BOOL, BOOLEAN

TINYINT

SMALLINT[(M)]

비트열

BIT VARYING (1073741823)

LONGBLOB

BLOB

LONG RAW

BIT VARYING(16277215)

MEDIUMBLOB

BIT VARYING(255)

TINYBLOB

-

BIT VARYING(65535)

BLOB

-

BIT(n)

BIT( > 1) (>MySQL-5.0)

-

BITVARYING(n)

BINARY(M)

RAW(n)

VARBINARY(M)

날짜/시간

DATE

DATE

DATE

: MM/DD/YYYY

: YYYY-MM-DD

: YY/MM/DD

DATETIME

DATETIME

TIMESTAMP

: YYYY-MM-DD HH:MI:SS.FFF 

: YYYY-MM-DD HH:MI:SS

TIMESTAMP WITH LOCAL TIMESTAMP WITH TIME ZONE

: YY/MM/DD HH:MI:SS.FFFF

TIME

TIME

-

: HH:MI:SS

: HH:MI:SS

TIMESTAMP

TIMESTAMP

TIMESTAMP

: YYYY-MM-DD HH:MI:SS

: YYYY-MM-DD HH:MI:SS

: YY/MM/DD HH:MI:SS.FFFFFFFFF

-

YEAR[(2|4)]

-

: YYYY

문자열

CHAR

CHAR

CHAR

NCHAR VARYING

-

-

NCHAR

-

NCHAR

VARCHAR(16277215)

MEDIUMTEXT

-

VARCHAR(255)

TINYTEXT

INTERVAL DAY TO SECOND

VARCHAR(255)

ENUM('value1','value2',...)

INTERVAL YEAR TO MONTH

VARCHAR(64)

-

ROWID

VARCHAR(64)

-

UROWID

VARCHAR(65535)

TEXT

-

VARCHAR

VARCHAR

NVARCHAR2

VARCHAR2

BLOB

BLOB

BLOB

BLOB

/CLOB

CLOB

-

CLOB

집합형

SET(VARCHAR(255))

SET('value1','value2',...)

-

MULTISET

-

-

LIST

-

-

SEQUENCE

-

-

STRING

LONGTEXT

CLOB

-

-

LONG

-

-

NCLOB

구분

CUBRID 연산자

MySQL 지원여부

논리 연산자

AND, &&

O

OR, ||

O

XOR

O

NOT, !

O

비교 연산자

=

O

<=>

O

<>, !=

O

> 

O

< 

O

>=

O

<=

O

IS boolean_value

O

IS NOT boolean_value

O

산술 연산자

+

O

-

O

*

O

/

O

DIV

O

%, MOD

O

포함 연산자

A SETEQ B

X

A SETNEQ B

X

A SUPERSET B

X

A SUBSET B

X

A SUPERSETEQ B

X

A SUBSETEQ B

X

비트 연산자

&

O

|

O

^

O

~

O

<< 

O

>> 

O

구분

CUBRID 함수(옵션)

MySQL지원여부

비트함수

BIT_AND(expr)

O

BIT_OR(expr)

O

BIT_XOR(expr)

O

BIT_COUNT (expr)

O

문자열 함수

ASCII(str)

O

BIN( n )

O

BIT_LENGTH ( string )

O

CHAR_LENGTH( string )

O

CHARACTER_LENGTH( string )

O

CHR( number_operand )

CHAR

CONCAT( string1, string2 [,string3 [, ... [, stringN]...]])

O

CONCAT_WS( string1, string2 [,string3 [, ... [, stringN]...]])

O

ELT(N, string1, string2, ... )

O

ELT(N, string1, string2, ... )

O

FIELD( search_string, string1 [,string2 [, ... [, stringN]...]])

O

FIND_IN_SET(str, strlist)

O

INSERT( str, pos, len, string )

O

INSTR( string , substring [, position] )

O

LCASE ( string )

O

LEFT( string , length )

O

LENGTH( string )

O

LENGTHB( string )

X

LOCATE ( substring, string [, position] )

LOCATE

LOAD_FILE

LOWER ( string )

O

LPAD( char1, n, [, char2 ] )

O

LTRIM( string [, trim_string])

O

MID( string, position, substring_length )

O

OCTET_LENGTH ( string )

O

POSITION ( substring IN string )

O

REPEAT( string, count )

O

REPLACE( string, search_string [, replacement_string ] )

O

REVERSE( string )

O

RIGHT( string , length )

O

RPAD( char1, n, [, char2 ] ) 

O

RTRIM( string [, trim_string])

O

SPACE(N)

O

STRCMP( string1 , string2 )

O

SUBSTR( string, position [, substring_length])

O

SUBSTRING( string FROM position [FOR substring_length] )

O

SUBSTRING( string, position [, substring_length])

O

SUBSTRING_INDEX (string, delim, count)

O

TRANSLATE( string, from_substring, to_substring )

X

TRIM ( [ [ LEADING | TRAILING | BOTH ] [ trim_string ] FROM ] string )

O

UCASE ( string )

O

UPPER ( string )

O

수치 연산 함수

ABS( number_operand )

O

ACOS( x )

O

ASIN ( x )

O

ATAN ( [y,] x )

O

ATAN2 ( y, x )

O

CEIL( number_operand )

CEILING

CONV(number,from_base,to_base)

O

COS( x )

O

COT ( x )

O

DEGREES ( x )

O

DRAND( [seed] )

X

DRANDOM( [seed] )

X

EXP( x )

O

FLOOR( number_operand )

O

FORMAT ( x , dec )

O

GREATEST ( expression [, expression]* )

O

HEX(num)

O

HEX(str)

O

LEAST( expression [, expression]* )

O

LN ( x )

O

LOG10 ( x )

O

LOG2 ( x )

O

MOD(m, n)

O

PI()

O

POW( x, y )

O

POWER( x, y )

O

RADIANS ( x )

O

RAND( [seed] )

O

RANDOM( [seed] )

X

ROUND( number_operand, integer )

O

SIGN(number_operand)

O

SIN( x )

O

SQRT( x )

O

TAN( x )

O

TRUNC( x[, dec] )

X

TRUNCATE( x, dec )

O

날짜/시간 함수

ADD_MONTHS ( date_argument , month )

X

ADDDATE(date, days)

O

ADDDATE(date, INTERVAL expr unit)

O

ADDTIME(expr1, expr2)

O

CURDATE()

O

CURRENT_DATE

O

CURRENT_DATE()

O

CURRENT_DATETIME

X

CURRENT_DATETIME()

X

CURRENT_TIME

O

CURRENT_TIME()

O

CURRENT_TIMESTAMP

O

CURRENT_TIMESTAMP()

O

CURTIME()

O

DATE(date)

O

DATE_ADD (date, INTERVAL expr unit)

O

DATE_SUB  (date, INTERVAL expr unit)

O

DATEDIFF (date1, date2)

O

DAY(date)

O

DAYOFMONTH(date)

O

DAYOFWEEK(date)

O

DAYOFYEAR(date)

O

EXTRACT ( field FROM date-time_argument )

O

FROM_DAYS(N)

O

FROM_UNIXTIME ( unix_timestamp[, format] )

O

LAST_DAY ( date_argument )

O

LOCALTIME

O

LOCALTIME()

O

LOCALTIMESTAMP

O

LOCALTIMESTAMP()

O

MAKEDATE(year, dayofyear)

O

MAKETIME(hour, min, sec)

O

MINUTE(time)

O

MONTH(date)

O

MONTHS_BETWEEN (date_argument, date_argument)

X

NOW()

O

QUARTER(date)

O

SEC_TO_TIME(second)

O

SECOND(time)

O

STR_TO_DATE(string, format)

O

SUBDATE(date, days)

O

SUBDATE(date, INTERVAL expr unit)

O

SYS_DATE

X

SYS_DATETIME

X

SYS_TIME

X

SYS_TIMESTAMP

X

SYSDATE

X

SYSDATETIME

X

SYSTIME

X

SYSTIMESTAMP

X

TIME(time)

O

TIME_TO_SEC(time)

O

TIMEDIFF(expr1, expr2)

O

TIMESTAMP(date [,time])

O

TO_DAYS(date)

O

UNIX_TIMESTAMP( [date] )

O

UTC_DATE()

O

UTC_TIME()

O

WEEK(date[, mode])

O

WEEKDAY(date)

O

YEAR(date)

O

데이터 타입 변환 함수

DATE_FORMAT(date, format)

O

TIME_FORMAT(time, format)

O

TO_CHAR( date_time [, format[, date_lang_string_literal ]] )

X

TO_CHAR(number_argument[, format_argument ])

X

TO_DATE(string_argument[,format_argument[,date_lang_string_literal]])

X

TO_DATETIME(string_argument[,format_argument[,date_lang_string_literal]])

X

TO_NUMBER(string_argument[, format_argument ])

X

TO_TIME(string_argument[,format_argument [,date_lang_string_literal]]):

X

TO_TIMESTAMP(string_argument[, format_argument[,date_lang_string_literal]])

X

집계함수

AVG  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

COUNT ( * | [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

GROUP_CONCAT ([DISTINCT] {col | expression}     

O

                   [ORDER BY {col | unsigned_int} [ASC | DESC]]

                   [SEPARATOR str_val])

MAX  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

MIN  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

STDDEV_POP ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL] expression )

STD

SUM  ( [ { DISTINCT | DISTINCTROW } | UNIQUE | ALL ] expression )

O

VAR_POP ( [ DISTINCT | UNIQUE | ALL] expression )

O

VAR_SAMP( [ DISTINCT | UNIQUE | ALL] expression )

O

VARIANCE

O

클릭 카운터 함수

INCR

X

정보함수

CURRENT_USER

O

DATABASE()

O

DEFAULT(column_name)

X

INDEX_CARDINALITY (table, index, key_pos)

X

LAST_INSERT_ID()

O

LIST_DBS()

X

ROW_COUNT()

O

SCHEMA()

O

SYSTEM_USER()

O

USER

X

USER()

O

VERSION()

O

암호화 함수

MD5(string)

O

조건 연산식과  함수

CASE control_expression simple_when_list[ else_clause ] END

O

CASE searched_when_list [ else_clause ] END

COALESCE(expression [, ...])

O

DECODE( expression, search, result [, search, result]* [, default] )

O

IF( expression1, expression2, expression3 )

O

IFNULL( expr1, expr2 )

O

NULLIF(expr1, expr2)

O

NVL( expr1, expr2 ) 

X

NVL2( expr1, expr2, expr3 )

X

CUBRID미지원 함수

ATN2

O

CRC32

O

DATENAME

O

LOAD_FILE

O

LOG

O

MAKE_SET

O

NCHAR

O

REPLICATE

O

SQUARE

O

UNICODE

O

CUBRID

MySQL

ORACLE

ABSOLUTE

-

-

-

-

ACCESS

ACTION

ACTION

-

ADD

ADD

ADD *

ADD_MONTHS

-

-

AFTER

-

-

ALIAS

-

-

ALL

ALL

ALL *

ALLOCATE

-

-

ALTER

ALTER

ALTER *

-

ANALYZE

-

AND

AND

AND *

ANY

-

ANY *

ARE

-

-

AS

AS

AS *

ASC

ASC

ASC *

ASSERTION

-

-

-

ASENSITIVE

-

ASYNC

-

-

AT

-

-

ATTACH

-

-

ATTRIBUTE

-

-

-

AUDIT

AUTO_INCREMENT

-

AVG

-

-

-

BDB

-

BEFORE

BEFORE

-

-

BERKELEYDB

-

BETWEEN

BETWEEN

BETWEEN *

BIGINT

BIGINT

-

-

BINARY

-

BIT

BIT

-

BIT_LENGTH

-

-

BLOB

BLOB

-

BOOLEAN

-

-

BOTH

BOTH

-

BREADTH

-

-

BY

BY

BY *

CALL

CALL

-

CASCADE

CASCADE

-

CASCADED

-

-

CASE

CASE

-

CAST

-

-

CATALOG

-

-

CHANGE

CHANGE

-

CHAR

CHAR

CHAR *

CHARACTER

CHARACTER

-

CHECK

CHECK

CHECK *

CLASS

-

-

CLASSES

-

-

CLOB

-

-

CLOSE

-

-

CLUSTER

-

CLUSTER

COALESCE

-

-

COLLATE

COLLATE

-

COLLATION

-

-

COLUMN

COLUMN

COLUMN

-

COLUMNS

-

-

CONDITION

-

-

-

COMMENT

COMMIT

-

-

COMPLETION

-

-

-

-

COMPRESS

CONNECT

-

CONNECT *

CONNECTION

CONNECTION

-

CONNECT_BY_ISCYCLE

-

-

CONNECT_BY_ISLEAF

-

-

CONNECT_BY_ROOT

-

-

CONSTRAINT

CONSTRAINT

-

CONSTRAINTS

-

-

CONTINUE

CONTINUE

-

CONVERT

-

-

CORRESPONDING

-

-

COUNT

-

-

CREATE

CREATE

CREATE *

CROSS

CROSS

-

CURRENT

-

CURRENT *

CURRENT_DATE

CURRENT_DATE

-

CURRENT_DATETIME

-

-

CURRENT_TIME

CURRENT_TIME

-

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP

-

CURRENT_USER

-

-

CURSOR

CURSOR

-

CYCLE

-

-

DATA

-

-

DATA_TYPE

-

-

DATABASE

DATABASE

-

-

DATABASES

-

DATE

DATE

DATE *

DATETIME

-

-

DAY

-

-

DAY_HOUR

DAY_HOUR

-

-

DAY_MICROSECOND

-

DAY_MILLISECOND

-

-

DAY_MINUTE

DAY_MINUTE

-

DAY_SECOND

DAY_SECOND

-

DEALLOCATE

-

-

DEC

DEC

-

DECIMAL

DECIMAL

DECIMAL *

DECLARE

DECLARE

-

DEFAULT

DEFAULT

DEFAULT *

DEFERRABLE

-

-

DEFERRED

-

-

-

DELAYED

-

DELETE

DELETE

DELETE *

DEPTH

-

-

DESC

DESC

DESC *

DESCRIBE

DESCRIBE

-

DESCRIPTOR

-

-

-

DETERMINISTIC

-

DIAGNOSTICS

-

-

DICTIONARY

-

-

DIFFERENCE

-

-

DISCONNECT

-

-

DISTINCT

DISTINCT

DISTINCT *

DISTINCTROW

DISTINCTROW

-

DIV

DIV

-

DO

-

-

DOMAIN

-

-

DOUBLE

DOUBLE

-

DROP

DROP

DROP *

DUPLICATE

-

-

EACH

-

-

ELSE

ELSE

ELSE *

ELSEIF

ELSEIF

-

-

ENCLOSED

-

END

-

-

-

ENUM

-

EQUALS

-

-

ESCAPE

-

-

-

ESCAPED

-

EVALUATE

-

-

EXCEPT

-

-

EXCEPTION

-

-

EXCLUDE

-

-

-

-

EXCLUSIVE

EXEC

-

-

EXECUTE

-

-

EXISTS

EXISTS

EXISTS

-

EXIT

-

-

EXPLAIN

-

EXTERNAL

-

-

EXTRACT

-

-

FALSE

FALSE

-

FETCH

FETCH

-

FILE

-

FILE

-

FIELDS

-

FIRST

-

-

FLOAT

FLOAT

FLOAT *

FOR

FOR

FOR *

-

FORCE

-

FOREIGN

FOREIGN

-

FOUND

FOUND

-

-

FRAC_SECOND

-