�w�b�_�[���X�L�b�v
Oracle TimesTen In-Memory Database SQL���t�@�����X�E�K�C�h
�����[�X7.0
E05176-01
�ڎ�
����
����
�ڎ�
���̃}�j���A���ɂ���
TimesTen�̃h�L�������g
�֘A����
�\�L�K��
�e�N�j�J���E�T�|�[�g
�f�[�^�^
�f�[�^�^�̎d�l
ANSI SQL�f�[�^�^
Oracle�^���[�h�ł̉��ʌ݊��p�ɃT�|�[�g����Ă���^
TimesTen�^�̃}�b�s���O
�����f�[�^�^
CHAR�^
NCHAR�^
VARCHAR2�^
NVARCHAR2�^
���l�f�[�^�^
���m�Ȑ��l�^�Ƌߎ��l�^
TT_TINYINT�^
TT_SMALLINT�^
TT_INTEGER�^
TT_BIGINT�^
NUMBER�^
���������_��
BINARY_FLOAT
BINARY_DOUBLE
FLOAT�����FLOAT (n)
BINARY�^�����VARBINARY�^
���l�̗D�揇��
�����f�[�^�^
TIME�^
TT_DATE�^
DATE�^
TT_TIMESTAMP�^
TIMESTAMP�^
TimesTen�̎��Ԋu
INTERVAL�^�̎g�p
DATE�^�����TIME�^�̎g�p
TIMEZONE�̕ϊ�����
�Z�p���Z�ɂ���������^����ю��Ԋu�^
��������ю��Ԋu�̎Z�p���Z�̐���
�L����v��
�f�[�^�^��r���[��
�f�[�^�ϊ�
�ÖٓI�ȃf�[�^�ϊ�
NULL�l
INF�����NAN
�I�[�o�[�t���[�Ɛ�̂�
�A���_�[�t���[
���v���P�[�V�����̐���
TimesTen�^���[�h�i���ʌ݊����[�h�j
TimesTen�^���[�h�ŃT�|�[�g����Ă���f�[�^�^
TimesTen�^���[�h�ŃT�|�[�g����Ă���Oracle�f�[�^�^
���O
��{��
���L�Җ�
�������ʎq
���I�p�����[�^
��
ROWID�̎w��
ROWNUM�̎w��
���̎w��
���⍇��
�W�v��
�萔
�������f��
���l�������f��
���l�����v�f
�����������f��
���������v�f
TimesTen�^TO_CHAR�̏������f��
ASCIISTR
CASE
CAST
CHR
USER��
CURRENT_USER
USER
SESSION_USER
SYSTEM_USER
COALESCE
CONCAT
DECODE
EXTRACT
LOWER�����UPPER
MOD
NCHR
NLSSORT
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
RTRIM
SYSDATE�����GETDATE
TO_CHAR
TO_DATE
TO_NUMBER
TRUNC (��)
TRUNC (���t)
TT_HASH
UNISTR
�������
SUBSTR
INSTR
LENGTH
��������
���������̈�ʓI�ȍ\��
ALL/ NOT IN�����i���⍇���j
ALL/ NOT IN�����i�l���X�g�j
ANY/ IN�����i���⍇���j
ANY/ IN�����i�l���X�g�j
BETWEEN����
��r����
EXISTS����
IS INFINITE����
IS NAN����
IS NULL����
LIKE����
NCHAR��NVARCHAR2
SQL��
�A�N�Z�X�����SQL��
SQL���̃��X�g
ALTER ACTIVE STANDBY PAIR
ALTER CACHE GROUP
ALTER REPLICATION
ALTER SESSION
ALTER TABLE
ALTER USER
CREATE ACTIVE STANDBY PAIR
CREATE CACHE GROUP
���[�U�[�Ǘ��L���b�V���E�O���[�v����уV�X�e���Ǘ��L���b�V���E�O���[�v
CREATE READONLY CACHE GROUP
CREATE ASYNCHRONOUS WRITETHROUGH CACHE GROUP
CREATE SYNCHRONOUS WRITETHROUGH CACHE GROUP
CREATE USERMANAGED CACHE GROUP
�L���b�V���E�O���[�v��AUTOREFRESH
CREATE INDEX
CREATE MATERIALIZED VIEW
�}�e���A���C�Y�h�E�r���[�ƃf�B�e�[���\�̐�������
MATERIALIZED VIEW�⍇���̐���
CREATE REPLICATION
CHECK CONFLICTS
CREATE SEQUENCE
CURRVAL��NEXTVAL�ɂ��SEQUENCE�l�̑���
CREATE TABLE
���`
CREATE USER
CREATE VIEW
VIEW�⍇���̐���
VIEW�̐���
DELETE
DROP ACTIVE STANDBY PAIR
DROP CACHE GROUP
DROP INDEX
DROP SEQUENCE
DROP REPLICATION
DROP TABLE
DROP USER
DROP VIEW
FLUSH CACHE GROUP
GRANT
INSERT
SingleRowValues
INSERT SELECT
LOAD CACHE GROUP
MERGE
REFRESH CACHE GROUP
REVOKE
SELECT
SelectList
TableSpec
DerivedTable
JoinedTable
TRUNCATE TABLE
UNLOAD CACHE GROUP
UPDATE
�����X�V
�V�X�e������у��v���P�[�V�����\
�V�X�e���\�̃��X�g
���v���P�[�V�����\�̃��X�g
�����I�Ȏg�p�܂��͏����̎g�p�̂��߂ɗ\�ꂽ�\
SYS.CACHE_GROUP
SYS.COLUMNS
SYS.COL_STATS
SYS.DUAL
SYS.INDEXES
SYS.MONITOR
SYS.PLAN
SYS.SEQUENCES
SYS.SYNONYMS
SYS.TABLES
SYS.TBL_STATS
SYS.TCOL_STATS
SYS.TINDEXES
SYS.TRANSACTION_LOG_API
SYS.TTABLES
SYS.TTBL_STATS
SYS.VIEWS
SYS.XLASUBSCRIPTIONS
TTREP.REPELEMENTS
TTREP.REPLICATIONS
TTREP.REPPEERS
TTREP.REPSTORES
TTREP.REPSUBSCRIPTIONS
TTREP.REPTABLES
TTREP.TTSTORES
�A�N�Z�X���䌠��
�����̐���
�C���X�^���X�Ǘ��Ҍ������K�v�ȑ���
SQL����
���[�e�B���e�B
ADMIN�������K�v�ȑ���
����
�g���݃v���V�[�W��
SQL����
���[�e�B���e�B
���[�e�B���e�BC API
XLA��
CONNECT�������K�v�ȑ���
CREATE DATASTORE�������K�v�ȑ���
DDL�������K�v�ȑ���
�g���݃v���V�[�W��
SQL����
WRITE�������K�v�ȑ���
�g���݃v���V�[�W��
SQL����
XLA��
SELECT�������K�v�ȑ���
�g���݃v���V�[�W��
SQL����
���[�e�B���e�B
�\���