Home
Home
Help
Help
Contact us
Contact Us

SQL, PL/SQL, and SQL*Plus Syntax and Examples: T

Shortcuts to Items in the List

Statements, Keywords, Packages, and Functions

CALENDARPRINT Procedures: Definition
CALIBRATE Function: Definition
CALIBRATE_IO Procedure: Definition
CANCEL_ANALYSIS_TASK Procedure: Definition
CANCEL_DIAGNOSIS_TASK Procedure: Definition
CANCEL_REPLAY Procedure: Definition
CANCEL_TASK Procedure: Definition
CANCEL_TUNING_TASK Procedure: Definition
CANONICALIZE Procedure: Definition
CAN_REDEF_TABLE Procedure: Definition
CAPTURE_CURSOR_CACHE_SQLSET Procedure: Definition
CASE: Definition
CASE Expressions: Definition
CASE Statement: Definition
CAST: Definition
CAST_FROM_BINARY_DOUBLE Function: Definition
CAST_FROM_BINARY_FLOAT Function: Definition
CAST_FROM_BINARY_INTEGER Function: Definition
CAST_FROM_NUMBER Function: Definition
CAST_TO_BINARY_DOUBLE Function: Definition
CAST_TO_BINARY_FLOAT Function: Definition
CAST_TO_BINARY_INTEGER Function: Definition
CAST_TO_NUMBER Function: Definition
CAST_TO_NVARCHAR2 Function: Definition
CAST_TO_RAW Function: Definition
CAST_TO_VARCHAR2 Function: Definition
CEIL: Definition
CELLSPRINT Procedures: Definition
CENTER Function: Definition
CENTER Procedure: Definition
CENTERCLOSE Function: Definition
CENTERCLOSE Procedure: Definition
CENTEROPEN Function: Definition
CENTEROPEN Procedure: Definition
CFG_GET Function: Definition
CFG_REFRESH Procedure: Definition
CFG_UPDATE Procedure: Definition
CHANGE: Definition
CHANGE Procedure: Definition
CHANGEOWNER Procedure: Definition
CHANGEPRIVILEGES Function: Definition
CHAR: Definition
CHECK CONFLICTS: Definition
CHECKACCESS Function: Definition
CHECKIN Function: Definition
CHECKOUT Procedure: Definition
CHECKPRIVILEGES Function: Definition
CHECKSUM Functions: Definition
CHECK_DB Function: Definition
CHECK_EXTERNAL Function: Definition
CHECK_OBJECT Procedure: Definition
CHECK_PRIVILEGE Function: Definition
CHECK_PRIVILEGE_ACLID Function: Definition
CHOOSE_DATE Procedure: Definition
CHR: Definition
CITE Function: Definition
CITE Procedure: Definition
CLEANUPUNUSEDBACKUPFILES Procedure: Definition
CLEANUP_GATEWAY Procedures: Definition
CLEANUP_INSTANTIATION_SETUP Procedure: Definition
CLEAN_AUDIT_TRAIL Procedure: Definition
CLEAR: Definition
CLEAR Procedure: Definition
CLEARKEYCOLUMNLIST: Definition
CLEARUPDATECOLUMNLIST: Definition
CLEAR_ALL_CONTEXT Procedure: Definition
CLEAR_AUDIT_TRAIL_PROPERTY Procedure: Definition
CLEAR_CONTEXT Procedure: Definition
CLEAR_COOKIES Procedure: Definition
CLEAR_EXPRSET_STATS Procedure: Definition
CLEAR_IDENTIFIER Procedure: Definition
CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure: Definition
CLEAR_PENDING_AREA Procedure: Definition
CLEAR_PLSQL_TRACE Procedure: Definition
CLEAR_USED Procedure: Definition
CLIENT_ID_STAT_DISABLE Procedure: Definition
CLIENT_ID_STAT_ENABLE Procedure: Definition
CLIENT_ID_TRACE_DISABLE Procedure: Definition
CLIENT_ID_TRACE_ENABLE Procedure: Definition
CLOB2FILE Procedure: Definition
CLONENODE Function: Definition
CLONE_SIMPLE_TABLESPACE Procedure: Definition
CLONE_TABLESPACES Procedure: Definition
CLOSE Procedure: Definition
CLOSE Statement: Definition
CLOSECONTEXT: Definition
CLOSECONTEXT Procedure: Definition
CLOSE_ALL_CONNECTIONS Procedure: Definition
CLOSE_CONNECTION Procedure: Definition
CLOSE_CURSOR Procedure: Definition
CLOSE_DATABASE_LINK Procedure: Definition
CLOSE_ITERATOR Procedure: Definition
CLOSE_PERSISTENT_CONN Procedure: Definition
CLOSE_PERSISTENT_CONNS Procedure: Definition
CLOSE_WINDOW Procedure: Definition
COALESCE: Definition
CODE Function: Definition
CODE Procedure: Definition
COLLECT_STATS Procedure: Definition
COLUMN: Definition
COLUMN NOPRINT: Definition
COLUMN_PRESENT Function: Definition
COLUMN_VALUE Procedure: Definition
COLUMN_VALUE_LONG Procedure: Definition
COMMAND_REPLIES Function: Definition
COMMA_TO_TABLE Procedures: Definition
COMMENT Function: Definition
COMMENT Procedure: Definition
COMMIT: Definition
COMMIT Procedure: Definition
COMMIT Statement: Definition
COMMIT_COMMENT Procedure: Definition
COMMIT_FORCE Procedure: Definition
COMPARE Function: Definition
COMPARE Functions: Definition
COMPARE_OLD_VALUES Procedure: Definition
COMPARE_PERIOD_REPORT Procedure: Definition
COMPATIBILITY Option: Definition
COMPATIBLE_10_1 Function: Definition
COMPATIBLE_10_2 Function: Definition
COMPATIBLE_11_1 Function: Definition
COMPATIBLE_11_2 Function: Definition
COMPATIBLE_9_2 Function: Definition
COMPILESCHEMA Procedure: Definition
COMPILE_FROM_REMOTE Procedure: Definition
COMPILE_SCHEMA Procedure: Definition
COMPUTE: Definition
COMPUTE_CONFUSION_MATRIX Procedure: Definition
COMPUTE_LIFT Procedure: Definition
COMPUTE_ROC Procedure: Definition
CONCAT: Definition
CONCAT Function: Definition
CONDITION_REF Function: Definition
CONFIGURE Procedure: Definition
CONFIGUREAUTOSYNC Procedure: Definition
CONFIGURE_POOL Procedure: Definition
CONNECT: Definition
CONNECTION Type: Definition
CONSTRUCT Function: Definition
CONSUME_EVENT Function: Definition
CONSUME_PRIM_EVENTS Function: Definition
CONTAINS_HOST Function: Definition
CONTINUE Function: Definition
CONTINUE Statement: Definition
CONTINUE statement: Definition
CONTINUE WHEN Statement: Definition
CONVERGE Procedure: Definition
CONVERT Function: Definition
CONVERT Functions: Definition
CONVERTTOBLOB Procedure: Definition
CONVERTTOCLOB Procedure: Definition
CONVERT_ANYDATA_TO_LCR_DDL Function: Definition
CONVERT_ANYDATA_TO_LCR_ROW Function: Definition
CONVERT_JMS_SELECTOR: Definition
CONVERT_LCR_TO_XML Function: Definition
CONVERT_RAW_VALUE Procedures: Definition
CONVERT_RAW_VALUE_NVARCHAR Procedure: Definition
CONVERT_RAW_VALUE_ROWID Procedure: Definition
CONVERT_XML_TO_LCR Function: Definition
COPIES Function: Definition
COPY: Definition
COPY Procedures: Definition
COPYDEFAULTTOKENTABLESET Procedure: Definition
COPYEVOLVE Procedure: Definition
COPY_ATTRIBUTE_SET Procedure: Definition
COPY_DBFS_LINK Procedures: Definition
COPY_FILE Procedure: Definition
COPY_FROM_DBFS_LINK: Definition
COPY_JOB Procedure: Definition
COPY_SQLWKLD_TO_STS Procedure: Definition
COPY_TABLE_DEPENDENTS Procedure: Definition
COPY_TABLE_STATS Procedure: Definition
COUNT Method: Definition
CQ_NOTIFICATION_QUERYID Function: Definition
CREATE ACTIVE STANDBY PAIR: Definition
CREATE CACHE GROUP: Definition
CREATE FUNCTION: Definition
CREATE FUNCTION Statement: Definition
CREATE INDEX: Definition
CREATE LIBRARY Statement: Definition
CREATE MATERIALIZED VIEW: Definition
CREATE MATERIALIZED VIEW LOG: Definition
CREATE PACKAGE: Definition
CREATE PACKAGE BODY: Definition
CREATE PACKAGE BODY Statement: Definition
CREATE PACKAGE Statement: Definition
CREATE PROCEDURE: Definition
CREATE PROCEDURE Statement: Definition
CREATE REPLICATION: Definition
CREATE SEQUENCE: Definition
CREATE TABLE: Definition
CREATE TRIGGER Statement: Definition
CREATE TYPE BODY Statement: Definition
CREATE TYPE Statement: Definition
CREATE USER: Definition
CREATE VIEW: Definition
CREATEATTRIBUTE Functions: Definition
CREATEBUCKET Procedure: Definition
CREATECDATASECTION Function: Definition
CREATECOMMENT Function: Definition
CREATEDATASTOREPREF Procedure: Definition
CREATEDATEINDEX Procedure: Definition
CREATEDIRECTORY Procedure: Definition
CREATEDIRECTORY Procedures: Definition
CREATEDOCUMENT Function: Definition
CREATEDOCUMENTFRAGMENT Function: Definition
CREATEELEMENT Functions: Definition
CREATEENTITYREFERENCE Function: Definition
CREATEFILE Procedure: Definition
CREATEFILE Procedures: Definition
CREATEFILESYSTEM Procedure: Definition
CREATEFILTERPREF Procedure: Definition
CREATEFOLDER Function: Definition
CREATEINDEX Procedure: Definition
CREATELEXERPREF Procedure: Definition
CREATELINK Procedure: Definition
CREATELINK Procedures: Definition
CREATENONSCHEMABASEDXML: Definition
CREATENUMBERINDEX Procedure: Definition
CREATEOIDPATH Function: Definition
CREATEPREFERENCES Procedure: Definition
CREATEPROCESSINGINSTRUCTION Function: Definition
CREATEREFERENCE Procedure: Definition
CREATEREFERENCE Procedures: Definition
CREATEREPOSITORYXMLINDEX Procedure: Definition
CREATERESOURCE Functions: Definition
CREATESCHEMABASEDXML: Definition
CREATESECTIONGROUPPREF Procedure: Definition
CREATESTOPLISTPREF Procedure: Definition
CREATESTORAGEPREF Procedure: Definition
CREATESTORE Procedure: Definition
CREATETEMPORARY Procedures: Definition
CREATETEXTNODE Function: Definition
CREATEURI: Definition
CREATEWORLDLISTPREF Procedure: Definition
CREATEXML: Definition
CREATE_ACL Procedure: Definition
CREATE_AFFECTED_TABLE Procedure: Definition
CREATE_AGENT Procedure: Definition
CREATE_ALTER_TYPE_ERROR_TABLE Procedure: Definition
CREATE_ANALYSIS_TASK Functions: Definition
CREATE_APPLY Procedure: Definition
CREATE_AQ_AGENT Procedure: Definition
CREATE_ATTRIBUTE_SET Procedure: Definition
CREATE_AUTOLOG_CHANGE_SOURCE Procedure: Definition
CREATE_BASELINE_TEMPLATE Procedures: Definition
CREATE_BIN_CAT Procedure: Definition
CREATE_BIN_NUM Procedure: Definition
CREATE_CAPTURE Procedure: Definition
CREATE_CATEGORY Function: Definition
CREATE_CATEGORY Procedure: Definition
CREATE_CHAIN Procedure: Definition
CREATE_CHANGE_SET Procedure: Definition
CREATE_CHANGE_TABLE Procedure: Definition
CREATE_CHUNKS_BY_NUMBER_COL Procedure: Definition
CREATE_CHUNKS_BY_ROWID Procedure: Definition
CREATE_CHUNKS_BY_SQL Procedure: Definition
CREATE_CLIP Procedure: Definition
CREATE_COL_REM Procedure: Definition
CREATE_COMPARISON Procedure: Definition
CREATE_CONDITIONS_TABLE Procedure: Definition
CREATE_CONSUMER_GROUP Procedure: Definition
CREATE_CREDENTIAL Procedure: Definition
CREATE_DAD Procedure: Definition
CREATE_DATABASE_DESTINATION Procedure: Definition
CREATE_DIAGNOSIS_TASK Functions: Definition
CREATE_ERROR_LOG Procedure: Definition
CREATE_ERROR_TABLE Procedure: Definition
CREATE_EVALUATION_CONTEXT Procedure: Definition
CREATE_EVENT_SCHEDULE Procedure: Definition
CREATE_EVENT_STRUCT Procedure: Definition
CREATE_EXPFIL_INDEXES Procedure: Definition
CREATE_EXTENDED_STATS Function: Definition
CREATE_FILE Procedure: Definition
CREATE_FILE_GROUP Procedure: Definition
CREATE_FILE_WATCHER Procedure: Definition
CREATE_FILTER_SET Procedure: Definition
CREATE_GROUP Procedure: Definition
CREATE_HOTLOG_CHANGE_SOURCE Procedure: Definition
CREATE_INDEX_COST Procedure: Definition
CREATE_INTERFACE Procedure: Definition
CREATE_JOB Procedure: Definition
CREATE_JOBS Procedure: Definition
CREATE_JOB_CLASS Procedure: Definition
CREATE_MISS_CAT Procedure: Definition
CREATE_MISS_NUM Procedure: Definition
CREATE_MODEL Procedure: Definition
CREATE_MVIEW Function: Definition
CREATE_NORM_LIN Procedure: Definition
CREATE_NP_QUEUE Procedure: Definition
CREATE_OBJECT Procedure: Definition
CREATE_OBJECT_DEPENDENCY Procedure: Definition
CREATE_OR_REPLACE_VIEW: Definition
CREATE_OUTLINE Procedure: Definition
CREATE_PENDING_AREA Procedure: Definition
CREATE_PIPE Function: Definition
CREATE_PLAN Procedure: Definition
CREATE_PLAN_DIRECTIVE Procedure: Definition
CREATE_POLICY_GROUP Procedure: Definition
CREATE_PROGRAM Procedure: Definition
CREATE_PROPAGATION Procedure: Definition
CREATE_PURGE_JOB Procedure: Definition
CREATE_QUEUE Procedure: Definition
CREATE_QUEUE_TABLE Procedure: Definition
CREATE_REQUEST_CONTEXT Function: Definition
CREATE_RULE Procedure: Definition
CREATE_RULE_CLASS Procedure: Definition
CREATE_RULE_SET Procedure: Definition
CREATE_SCHEDULE Procedure: Definition
CREATE_SERVICE Procedure: Definition
CREATE_SIMPLE_PLAN Procedure: Definition
CREATE_SQLWKLD Procedure: Definition
CREATE_SQL_PLAN_BASELINE Procedure: Definition
CREATE_STAT_TABLE Procedure: Definition
CREATE_STGTAB_BASELINE Procedure: Definition
CREATE_STGTAB_SQLPATCH Procedure: Definition
CREATE_STGTAB_SQLPROF Procedure: Definition
CREATE_STGTAB_SQLSET Procedure: Definition
CREATE_STMT_HANDLER Procedure: Definition
CREATE_SUBSCRIPTION Procedure: Definition
CREATE_SYNC_CAPTURE Procedure: Definition
CREATE_TABLE_COST Procedures: Definition
CREATE_TABLE_TEMPLATE: Definition
CREATE_TASK Procedure: Definition
CREATE_TASK Procedures: Definition
CREATE_TRANSFORMATION Procedure: Definition
CREATE_TRIGGER_TABLE Procedure: Definition
CREATE_TUNING_TASK Functions: Definition
CREATE_VERSION Procedure: Definition
CREATE_WINDOW Procedure: Definition
CREATE_WINDOW_GROUP Procedure: Definition
CREATE_WRAPPED Procedures: Definition
CRLF: Definition
CTX_ADM: Definition
CTX_CLS: Definition
CTX_DDL: Definition
CTX_DOC: Definition
CTX_OUTPUT: Definition
CTX_QUERY: Definition
CTX_REPORT: Definition
CTX_THES: Definition
CTX_ULEXER: Definition
CURRENT_INSTANCE Function: Definition
CURRENT_USER: Definition
TABLECAPTION Function: Definition
TABLECAPTION Procedure: Definition
TABLECLOSE Function: Definition
TABLECLOSE Procedure: Definition
TABLEDATA Function: Definition
TABLEDATA Procedure: Definition
TABLEHEADER Function: Definition
TABLEHEADER Procedure: Definition
TABLEOPEN Function: Definition
TABLEOPEN Procedure: Definition
TABLEPRINT Function: Definition
TABLEROWCLOSE Function: Definition
TABLEROWCLOSE Procedure: Definition
TABLEROWOPEN Function: Definition
TABLEROWOPEN Procedure: Definition
TABLESPACE_FIX_BITMAPS Procedure: Definition
TABLESPACE_FIX_SEGMENT_STATES Procedure: Definition
TABLESPACE_MIGRATE_FROM_LOCAL Procedure: Definition
TABLESPACE_MIGRATE_TO_LOCAL Procedure: Definition
TABLESPACE_REBUILD_BITMAPS Procedure: Definition
TABLESPACE_REBUILD_QUOTAS Procedure: Definition
TABLESPACE_RELOCATE_BITMAPS Procedure: Definition
TABLESPACE_VERIFY Procedure: Definition
TABLE_CREATE Procedure: Definition
TABLE_TO_COMMA Procedures: Definition
TARGET_FILE Function: Definition
TARGET_LOB Function: Definition
TARGET_PROGRAM_RUNNING Procedure: Definition
TARGET_TABLE Function: Definition
TARGET_TRACE Function: Definition
TASK_STATUS Procedure: Definition
TELETYPE Function: Definition
TELETYPE Procedure: Definition
TERMINATE Procedure: Definition
TEXT_DECODE Function: Definition
TEXT_ENCODE Function: Definition
TIME: Definition
TIMESTAMP: Definition
TIMING: Definition
TITLE Function: Definition
TITLE Procedure: Definition
TODATE Function: Definition
TOOBJECT: Definition
TOUCHRESOURCE Procedure: Definition
TO_CHAR: Definition
TO_CURSOR_NUMBER Function: Definition
TO_DATE: Definition
TO_NUMBER: Definition
TO_REFCURSOR Function: Definition
TO_STRING Function: Definition
TRACE Procedure: Definition
TRACEENABLED Function: Definition
TRANSACTION_BACKOUT Procedures: Definition
TRANSFORM: Definition
TRANSFORMNODE Function: Definition
TRANSLATE Function: Definition
TRANSLATEXML Function: Definition
TRANSLITERATE Function: Definition
TRANSPORT_SET_CHECK Procedure: Definition
TRIM: Definition
TRIM Method: Definition
TRIM Procedures: Definition
TRUNC (date): Definition
TRUNC (expression): Definition
TRUNCATE TABLE: Definition
TTITLE: Definition
TTREP.REPELEMENTS: Definition
TTREP.REPLICATIONS: Definition
TTREP.REPNETWORK: Definition
TTREP.REPPEERS: Definition
TTREP.REPSTORES: Definition
TTREP.REPSUBSCRIPTIONS: Definition
TTREP.REPTABLES: Definition
TTREP.TTSTORES: Definition
TT_BIGINT: Definition
TT_DATE: Definition
TT_DB_VERSION: Definition
TT_HASH: Definition
TT_INTEGER: Definition
TT_SMALLINT: Definition
TT_TIMESTAMP: Definition
TT_TINYINT: Definition
TUNE_MVIEW Procedure: Definition
TYPE_BUILD Function: Definition
TYPE_DIMENSION_COMPILE Function: Definition
TYPE_OPERATIONS Function: Definition
TYPE_REJECTED_RECORDS Function: Definition