마이그레이션

CUBRID vs MySQL vs ORACLE SQL 타입별 비교

by 정만영 posted Jul 12, 2013

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

-

-

 

 


Articles

1