CUBRID vs MySQL vs ORACLE SQL 타입별 비교

CUBRID vs MySQL vs ORACLE SQL 타입별 비교

 

CUBRID 8.4.1 vs MySQL 5.5.27 vs  ORACLE 10g 에 대한 SQL 관련 정보들을 비교한다.

 

 

1.    CUBRID와 데이터 타입     

    

           1). DBMS별 데이터 타입 비교

구분	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

 

           2). 마이그레이션 할 때 권장하는 데이터 타입 맵핑 테이블- MySQL to CUBRID

Date Types in MySQL	Date Types in CUBRID
BIT(1) (>MySQL-5.0)	SMALLINT
BIT( > 1) (>MySQL-5.0)	BIT(n)
TINYINT	SMALLINT
BOOL, BOOLEAN	SMALLINT
SMALLINT[(M)]	SMALLINT
	INT
MEDIUMINT[(M)]	INT
INT, INTEGER[(M)]	INT
	BIGINT
BIGINT[(M)]	BIGINT
	NUMERIC(20)
FLOAT[(M,D)]	FLOAT
DOUBLE[(M,B)]	DOUBLE
DECIMAL[(M[,D])]	DOUBLE
DATE	DATE
DATETIME	DATETIME
TIMESTAMP[(M)]	TIMESTAMP
TIME	TIME
YEAR[(2|4)]	CHAR(4)
CHAR(M)	CHAR(n)
VARCHAR(M) [BINARY]	VARCHAR(n)
BINARY(M)	BIT VARYING(n)
VARBINARY(M)	BIT VARYING(n)
TINYBLOB	BIT VARYING(255)
TINYTEXT	VARCHAR(255)
BLOB	BIT VARYING(65535)
TEXT	VARCHAR(65535)
MEDIUMBLOB	BIT VARYING(16277215)
MEDIUMTEXT	VARCHAR(16277215)
LONGBLOB	BIT VARYING (1073741823)
LONGTEXT	STRING
ENUM('value1','value2',...)	VARCHAR(255)
SET('value1','value2',...)	SET(VARCHAR(255))
FLOAT(M,D) or REAL(M,D) or DOUBLE PRECISION(M,D)	NUMERIC(M,D)

 

 

           3). 마이그레이션 할 때 권장하는 데이터 타입 맵핑 테이블- ORACLE to CUBRID

Date Types in Oracle	Date Types in CUBRID
BINARY_DOUBLE	DOUBLE
BINARY_FLOAT	FLOAT
BLOB	BIT VARYING (1073741823)
CHAR(n)	CHAR(n)
CLOB	STRING
DATE	DATE
DECIMAL(p, s)	NUMERIC(p, s)
FLOAT	FLOAT
INTERVAL DAY TO SECOND	VARCHAR(255)
INTERVAL YEAR TO MONTH	VARCHAR(255)
LONG	STRING
LONG RAW	BIT VARYING (1073741823)
NCHAR(n)	CHAR(n)
NCLOB	STRING
NUMBER(p, s)	NUMERIC(p, s)
NUMBER	NUMERIC(38, 15)
NUMBER(p,0)	NUMERIC(38, 0)
NVARCHAR2(n)	VARCHAR(n)
RAW(n)	BIT VARYING(n)
ROWID	VARCHAR(64)
TIMESTAMP	DATETIME
TIMESTAMP WITH LOCAL TIME ZONE	DATETIME
TIMESTAMP WITH TIME ZONE	DATETIME
UROWID	VARCHAR(64)
VARCHAR2(n)	VARCHAR(n)

 

 

2.    CUBRID 지원 연산자와 함수

           1). CUBRID 지원연산자

구분	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

 

           2). CUBRID 지원함수

구분	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

 

 

 

3.    CUBRID 예약어

1). DBMS별 예약어 비교

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	-
FROM	FROM	FROM *
FULL	-	-
-	FULLTEXT	-
FUNCTION	-	-
GENERAL	-	-
GET	-	-
GLOBAL	-	-
GO	-	-
GOTO	-	-
GRANT	GRANT	GRANT *
GROUP	GROUP	GROUP *
HAVING	HAVING	HAVING *
-	HIGH_PRIORITY	-
HOUR	-	-
HOUR_MILLISECOND	HOUR_MICROSECOND	-
HOUR_MINUTE	HOUR_MINUTE	-
HOUR_SECOND	HOUR_SECOND	-
-	-	IDENTIFIED
IDENTITY	-	-
IF	IF	-
IGNORE	IGNORE	-
IMMEDIATE	-	IMMEDIATE *
IN	IN	IN *
-	-	INCREMENT
INDEX	INDEX	INDEX
INDICATOR	-	-
-	INFILE	-
INHERIT	-	-
-	-	INITIAL
INITIALLY	-	-
INNER	INNER	-
-	INNODB	-
INOUT	INOUT	-
INPUT	-	-
-	INSENSITIVE	-
INSERT	INSERT	INSERT *
INT	INT	-
INTEGER	INTEGER	INTEGER *
INTERSECT	-	INTERSECT *
INTERSECTION	-	-
INTERVAL	INTERVAL	-
INTO	INTO	INTO *
-	IO_THREAD	-
IS	IS	IS *
ISOLATION	-	-
-	ITERATE	-
JOIN	JOIN	-
KEY	KEY	-
-	KEYS	-
-	KILL	-
LANGUAGE	-	-
LAST	-	-
LDB	-	-
LEADING	LEADING	-
LEAVE	LEAVE	-
LEFT	LEFT	-
LESS	-	-
LEVEL	-	LEVEL *
LIKE	LIKE	LIKE *
LIMIT	LIMIT	-
LIST	-	-
-	LINES	-
-	LOAD	-
LOCAL	-	-
LOCAL_TRANSACTION_ID	-	-
LOCALTIME	LOCALTIME	-
LOCALTIMESTAMP	LOCALTIMESTAMP	-
-	LOCK	LOCK
-	LONG	LONG
-	LONGBLOB	-
-	LONGTEXT	-
LOOP	LOOP	-
LOWER	-	-
-	LOW_PRIORITY	-
-	MASTER_SERVER_ID	-
MATCH	MATCH	-
MAX	-	-
-	-	MAXEXTENTS
METHOD	-	-
-	MEDIUMBLOB	-
-	MEDIUMINT	-
-	MEDIUMTEXT	-
-	MIDDLEINT	-
MILLISECOND	-	-
MIN	-	-
MINUTE	-	-
-	-	MINUS
-	MINUTE_MICROSECOND	-
MINUTE_MILLISECOND	-	-
MINUTE_SECOND	MINUTE_SECOND	-
-	-	MLSLABEL
MOD	MOD	-
-	-	MODE
MODIFY	-	MODIFY
MODULE	-	-
MONETARY	-	-
MONTH	-	-
MULTISET	-	-
MULTISET_OF	-	-
NA	-	-
NAMES	-	-
NATIONAL	NATURAL	-
NATURAL	-	-
NCHAR	-	-
NEXT	-	-
NO	NO	-
-	NO_WRITE_TO_BINLOG	-
-	-	-
-	-	NOAUDIT
NONE	-	NOCOMPRESS
NOT	NOT	NOT *
-	-	NOWAIT
NULL	NULL	NULL *
NULLIF	-	-
-	-	NUMBER
NUMERIC	NUMERIC	-
OBJECT	-	-
OCTET_LENGTH	-	-
OF	-	OF *
OFF	-	-
-	-	OFFLINE
OID	-	-
ON	ON	ON *
-	-	ONLINE
ONLY	-	-
OPEN	-	-
OPERATION	-	-
OPERATORS	-	-
-	OPTIMIZE	-
OPTIMIZATION	-	-
OPTION	OPTION	OPTION *
-	OPTIONALLY	-
OR	OR	OR *
ORDER	ORDER	ORDER *
OTHERS	-	-
OUT	OUT	-
OUTER	OUTER	-
-	OUTFILE	-
OUTPUT	-	-
OVERLAPS	-	-
PARAMETERS	-	-
PARTIAL	-	-
-	-	PCTFREE
PENDANT	-	-
POSITION	-	-
PRECISION	PRECISION	-
PREORDER	-	-
PREPARE	-	-
PRESERVE	-	-
PRIMARY	PRIMARY	-
PRIOR	-	PRIOR *
PRIVATE	-	-
PRIVILEGES	PRIVILEGES	PRIVILEGES *
PROCEDURE	PROCEDURE	-
PROTECTED	-	-
PROXY	-	-
-	-	PUBLIC *
-	PURGE	-
QUERY	-	-
-	-	RAW
-	-	-
READ	READ	-
REAL	REAL	-
RECURSIVE	-	-
REF	-	-
REFERENCES	REFERENCES	-
REFERENCING	-	-
REGEXP	REGEXP	-
REGISTER	-	-
RELATIVE	-	-
RENAME	RENAME	RENAME
-	REPEAT	-
REPLACE	REPLACE	-
RESIGNAL	-	-
-	-	RESOURCE
-	REQUIRE	-
RESTRICT	RESTRICT	-
RETURN	RETURN	-
RETURNS	-	-
REVOKE	REVOKE	REVOKE *
RIGHT	RIGHT	-
RLIKE	RLIKE	-
ROLE	-	-
ROLLBACK	-	-
ROLLUP	-	-
ROUTINE	-	-
ROW	-	ROW
-	-	ROWID
ROWNUM	-	ROWNUM
ROWS	-	ROWS *
SAVEPOINT	-	-
SCHEMA	-	-
SCOPE	-	-
SCROLL	-	-
SEARCH	-	-
SECOND	-	-
-	SECOND_MICROSECOND	-
SECOND_MILLISECOND	-	-
SECTION	-	-
SELECT	SELECT	SELECT *
SENSITIVE	SENSITIVE	-
-	SEPARATOR	-
SEQUENCE	-	-
SEQUENCE_OF	-	-
SERIALIZABLE	-	-
SESSION	-	SESSION *
SESSION_USER	-	-
SET	SET	SET *
SET_OF	-	-
SETEQ	-	-
-	-	SHARE
SHARED	-	-
-	SHOW	-
SIBLINGS	-	-
SIGNAL	-	-
SIMILAR	-	-
SIZE	-	SIZE *
SMALLINT	SMALLINT	SMALLINT *
SOME	SOME	-
-	SONAME	-
-	SPATIAL	-
-	SPECIFIC	-
SQL	SQL	-
SQLCODE	-	-
SQLERROR	-	-
-	SQL_BIG_RESULT	-
-	SQL_CALC_FOUND_ROWS	-
-	SQL_SMALL_RESULT	-
-	SQL_TSI_DAY	-
-	SQL_TSI_FRAC_SECOND	-
-	SQL_TSI_HOUR	-
-	SQL_TSI_MINUTE	-
-	SQL_TSI_MONTH	-
-	SQL_TSI_QUARTER	-
-	SQL_TSI_SECOND	-
-	SQL_TSI_WEEK	-
-	SQL_TSI_YEAR	-
SQLEXCEPTION	SQLEXCEPTION	-
SQLSTATE	SQLSTATE	-
SQLWARNING	SQLWARNING	-
-	SSL	-
-	-	START
-	STARTING	-
STATISTICS	-	-
-	STRAIGHT_JOIN	-
STRING	-	-
-	STRIPED	-
STRUCTURE	-	-
SUBCLASS	-	-
SUBSET	-	-
SUBSETEQ	-	-
SUBSTRING	-	-
-	-	SUCCESSFUL
SUM	-	-
SUPERCLASS	-	-
SUPERSET	-	-
SUPERSETEQ	-	-
-	-	SYNONYM
SYS_CONNECT_BY_PATH	-	-
SYS_DATE	-	-
SYS_DATETIME	-	-
SYS_TIME	-	-
SYS_TIMESTAMP	-	-
SYS_USER	-	-
SYSDATE	-	SYSDATE
SYSDATETIME	-	-
SYSTEM_USER	-	-
SYSTIME	-	-
TABLE	TABLE	TABLE *
-	TABLES	-
TEMPORARY	-	-
-	TERMINATED	-
TEST	-	-
-	TEXT	-
THEN	THEN	THEN *
THERE	-	-
TIME	TIME	-
TIMESTAMP	TIMESTAMP	-
-	TIMESTAMPADD	-
-	TIMESTAMPDIFF	-
TIMEZONE_HOUR	-	-
TIMEZONE_MINUTE	-	-
-	TINYBLOB	-
-	TINYINT	-
-	TINYTEXT	-
TO	TO	TO *
TRAILING	TRAILING	-
TRANSACTION	-	-
TRANSLATE	-	-
TRANSLATION	-	-
TRIGGER	-	TRIGGER
TRIM	-	-
TRUE	TRUE	-
TRUNCATE	-	-
TYPE	-	-
-	-	UID
UNDER	-	-
-	UNDO	-
UNION	UNION	UNION *
-	-	-
UNIQUE	UNIQUE	UNIQUE *
UNKNOWN	-	-
-	UNLOCK	-
-	UNSIGNED	-
UPDATE	UPDATE	UPDATE *
UPPER	-	-
USAGE	USAGE	-
USE	USE	-
USER	-	USER *
-	USER_RESOURCES	-
USING	USING	-
UTIME	-	-
-	UTC_DATE	-
-	UTC_TIME	-
-	UTC_TIMESTAMP	-
-	-	VALIDATE
VALUE	-	-
VALUES	VALUES	VALUES *
-	VARBINARY	-
VARCHAR	VARCHAR	VARCHAR *
-	-	VARCHAR2
VARIABLE	-	-
-	VARCHARACTER	-
VARYING	VARYING	-
VCLASS	-	-
VIEW	-	VIEW *
VIRTUAL	-	-
VISIBLE	-	-
WAIT	-	-
WHEN	WHEN	-
WHENEVER	-	WHENEVER *
WHERE	WHERE	WHERE
WHILE	WHILE	-
WITH	WITH	WITH *
WITHOUT	-	-
WORK	-	-
WRITE	WRITE	-
XOR	XOR	-
YEAR	-	-
YEAR_MONTH	YEAR_MONTH	-
-	ZEROFILL	-
ZONE	-	-

 

[출처] CUBRID vs MySQL vs ORACLE SQL 타입별 비교 (큐브리드 공부하기) |작성자 이조건