SQL Reference Manual |
Data Definition |
Ensuring Data Integrity |
CREATE TABLE Statement (create_table_statement) |
Column Definition (column_definition) |
Data Type (data_type) |
CHAR[ACTER]![End Level 6 Node: CHAR[ACTER]](../../images/1x1.gif) |
VARCHAR |
LOB Column |
Code Attribute |
BOOLEAN |
FIXED |
FLOAT |
INT[EGER]![End Level 6 Node: INT[EGER]](../../images/1x1.gif) |
SMALLINT |
DATE (Date Value) |
TIME (Time Value) |
TIMESTAMP (Time Stamp Value) |
NULL Value |
Special NULL Value |
Number |
Character String |
Column Attributes (column_attributes) |
Memory Requirements of a Column Value According to Data Type |
CONSTRAINT Definition (constraint_definition) |
Referential CONSTRAINT Definition (referential_constraint_defini |
Key Definition (key_definition) |
UNIQUE Definition (unique_definition) |
DROP TABLE Statement (drop_table_statement) |
ALTER TABLE Statement (alter_table_statement) |
ADD Definition (add_definition) |
ALTER Definition (alter_definition) |
COLUMN Change Definition (column_change_definition) |
DROP Definition (drop_definition) |
MODIFY Definition (modify_definition) |
RENAME TABLE Statement (rename_table_statement) |
RENAME COLUMN Statement (rename_column_statement) |
EXISTS TABLE Statement (exists_table_statement) |
CREATE SCHEMA Statement (create_schema_statement) |
RENAME SCHEMA Statement (rename_schema_statement) |
DROP SCHEMA Statement (drop_schema_statement) |
CREATE DOMAIN Statement (create_domain_statement) |
DROP DOMAIN Statement (drop_domain_statement) |
CREATE SEQUENCE Statement (create_sequence_statement) |
DROP SEQUENCE Statement (drop_sequence_statement) |
CREATE SYNONYM Statement (create_synonym_statement) |
DROP SYNONYM statement (drop_synonym_statement) |
RENAME SYNONYM Statement (rename_synonym_statement) |
CREATE VIEW Statement (create_view_statement) |
INSERT/UPDATE/DELETE Privilege for Owners of View Tables |
Updateable Join View Table |
DROP VIEW Statement (drop_view_statement) |
RENAME VIEW Statement (rename_view_statement) |
CREATE INDEX Statement (create_index_statement) |
DROP INDEX Statement (drop_index_statement) |
ALTER INDEX Statement (alter_index_statement) |
RENAME INDEX Statement (rename_index_statement) |
CREATE DBPROC[EDURE] Statement (create_dbproc_statement)![End Level 3 Node: CREATE DBPROC[EDURE] Statement (create_dbproc_statement)](../../images/1x1.gif) |
Routine (routine) |
General CASE Statement (searched_case_statement) |
Simple CASE Statement (simple_case_statement) |
DROP DBPROC[EDURE] Statement (drop_dbproc_statement)![End Level 3 Node: DROP DBPROC[EDURE] Statement (drop_dbproc_statement)](../../images/1x1.gif) |
CREATE SYSTEM TRIGGER Statement (create_system_trigger_statement |
DROP SYSTEM TRIGGER Statement (drop_system_trigger_statement) |
CREATE FUNCTION Statement (create_function_statement) |
DROP FUNCTION Statement (drop_function_statement) |
CREATE TRIGGER Statement (create_trigger_statement) |
DROP TRIGGER Statement (drop_trigger_statement) |
COMMENT ON Statement (comment_on_statement) |
Authorization |
CREATE USER Statement (create_user_statement) |
CREATE USERGROUP Statement (create_usergroup_statement) |
DROP USER Statement (drop_user_statement) |
DROP USERGROUP Statement (drop_usergroup_statement) |
ALTER USER Statement (alter_user_statement) |
ALTER USERGROUP Statement (alter_usergroup_statement) |
RENAME USER Statement (rename_user_statement) |
RENAME USERGROUP Statement (rename_usergroup_statement) |
GRANT USER Statement (grant_user_statement) |
GRANT USERGROUP Statement (grant_usergroup_statement) |
ALTER PASSWORD Statement (alter_password_statement) |
CREATE ROLE Statement (create_role_statement) |
DROP ROLE Statement (drop_role_statement) |
GRANT Statement (grant_statement) |
REVOKE Statement (revoke_statement) |
Data Manipulation |
INSERT Statement (insert_statement) |
Data Type of the Target Column and Data Type of the Value to be |
Join View Table, QUERY Expression, CONSTRAINT Definition, Trigge |
UPDATE Statement (update_statement) |
DELETE Statement (delete_statement) |
NEXT STAMP Statement (next_stamp_statement) |
CALL Statement (call_statement) |
Data Query |
QUERY Statement (query_statement) |
DECLARE CURSOR Statement (declare_cursor_statement) |
Recursive DECLARE CURSOR Statement (recursive_declare_cursor_sta |
SELECT Statement (select_statement) |
QUERY Expression (query_expression) |
Table Expression (table_expression) |
Subquery (subquery) |
ORDER Clause (order_clause) |
UPDATE Clause (update_clause) |
LOCK Option (lock_option) |
FETCH Statement (fetch_statement) |
CLOSE Statement (close_statement) |
SINGLE SELECT Statement (single_select_statement) |
EXPLAIN Statement (explain_statement) |
Transactions |
CONNECT Statement (connect_statement) |
SET Statement (set_statement) |
COMMIT Statement (commit_statement) |
ROLLBACK Statement (rollback_statement) |
SUBTRANS Statement (subtrans_statement) |
INNER TRANSACTION Statement (inner_transaction_statement) |
SQL SAVEPOINT Statements (savepoint/rollback_to_/release_savepoi |
LOCK Statement (lock_statement) |
UNLOCK Statement (unlock_statement) |
RELEASE Statement (release_statement) |
Statistics |
UPDATE STATISTICS Statement (update_statistics_statement) |
MONITOR Statement (monitor_statement) |
SQL Statements: Overview |
Comment (sql_comment) |
Frequently Used Syntax Elements: Overview |
CASCADE Option (cascade_option) |
Character (character) |
Column Specification (column_spec) |
DEFAULT Specification (default_spec) |
DELETE Rule (delete_rule) |
DISTINCT Specification (distinct_spec) |
DUPLICATES Clause (duplicates_clause) |
Expression (expression) |
Specifying Values (extended_value_spec) |
Function (function_spec) |
Arithmetic Function (arithmetic_function) |
ABS(a) |
CEIL(a) |
EXP(a) |
FIXED(a,p,s) |
FLOAT(a,p) |
FLOOR(a) |
INDEX(a,b,p,s) |
LENGTH(a) |
LN(a) |
LOG(a) |
NOROUND(a) |
PI |
POWER(a,n) |
ROUND(a,n) |
SIGN(a) |
SQRT(a) |
TRUNC(a,n) |
Conversion Function (conversion_function) |
CHAR(a,t) |
CHR(a,n) |
HEX(a) |
HEXTORAW(a) |
INTTORAW(a) |
NUM(a) |
Date and Time Format (datetimeformat) |
Date Function (date_function) |
ADDDATE/SUBDATE(t,a) |
ADD_MONTHS(t,a) |
DATEDIFF(t,s) |
DAYNAME/MONTHNAME(t) |
DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
MAKEDATE(a,b) |
Database Function Call (dbfunction_call) |
Extraction (extraction_function) |
DATE(a) |
HOUR/MINUTE/SECOND(t) |
MICROSECOND(a) |
TIME(a) |
TIMESTAMP(a,b) |
YEAR/MONTH/DAY(t) |
Special Function (special_function) |
DECODE(x,y(i),...,z) |
GREATEST/LEAST(x,y,...) |
VALUE(x,y,...) |
General CASE Function (searched_case_function) |
Simple CASE Function (simple_case_function) |
String Function (string_function) |
ALPHA(x,n) |
ASCII(x) |
CONCAT(x,y) |
EXPAND(x,n) |
INITCAP(x) |
LFILL(x,a,n) |
LPAD(x,a,y,n) |
LTRIM(x,y) |
MAPCHAR(x,n,i) |
REPLACE(x,y,z) |
RFILL(x,a,n) |
RPAD(x,a,y,n) |
RTRIM(x,y) |
SOUNDEX(x) |
SQLMODE() |
SUBSTR(x,a,b) |
TRANSLATE(x,y,z) |
TRIM(x,y) |
UPPER/LOWER(x) |
Time Function (time_function) |
ADDTIME/SUBTIME(t,a) |
MAKETIME(h,m,s) |
TIMEDIFF(t,s) |
Trigonometric Function (trigonometric_function) |
Joined Table (joined_table) |
Key Specification (key_spec) |
Literal (literal) |
Fixed Point Number (fixed_point_literal) |
Floating Point Number (floating_point_literal) |
Unsigned Integer (unsigned_integer) |
Integer (integer) |
Parameter Specification (parameter_spec) |
Predicate (predicate) |
BETWEEN Predicate (between_predicate) |
Boolean Predicate (bool_predicate) |
Comparison Predicate (comparison_predicate) |
DEFAULT Predicate (default_predicate) |
EXISTS Predicate (exists_predicate) |
IN Predicate (in_predicate) |
JOIN Predicate (join_predicate) |
LIKE Predicate (like_predicate) |
NULL Predicate (null_predicate) |
Quantified Predicate (quantified_predicate) |
ROWNO Predicate (rowno_predicate) |
SOUNDS Predicate (sounds_predicate) |
SAMPLE Definition (sample_definition) |
Search Condition (search_condition) |
Selected Column (select_column) |
Set Function (set_function_spec) |
Character Set (token) |
Identifier (identifier) |
Keyword (keyword) |
Functions: Overview |
Names: Overview |
Alias Name (alias_name) |
Column Name (column_name) |
Constraint Name (constraint_name) |
Data Source Name (data_source_name) |
Name of a Database Function (dbfunction_name) |
Name of a Database Procedure (dbproc_name) |
Domain Name (domain_name) |
Index Name (index_name) |
Indicator Name (indicator_name) |
MapChar Set Name (mapchar_set_name) |
Password (password) |
Parameter Name (parameter_name) |
Reference Name (reference_name) |
Name of a Referential Constraint (referential_constraint_name) |
Results Table Name (result_table_name) |
Role Name (role_name) |
Schema Name (schema_name) |
Sequence Name (sequence_name) |
Synonym Name (synonym_name) |
Table Name (table_name) |
Trigger Name (trigger_name) |
User Group Name (usergroup_name) |
User Name (user_name) |
Privileges: Overview |
Privilege Specification (priv_spec) |
Privilege Specification for a Schema (schema_priv_spec) |
SQL Syntax |
add_definition |
alias_name |
all_function |
alter_definition |
alter_index_statement |
alter_password_statement |
alter_table_statement |
alter_user_statement |
alter_usergroup_statement |
argument |
argument1 |
arithmetic_function |
ascii_or_unicode |
assignment_statement |
between_predicate |
bool_predicate |
boolean_factor |
boolean_term |
call_statement |
cascade_option |
case_else_clause |
case_function |
case_statement |
character |
check_expression |
close_statement |
column_attributes |
column_change_definition |
column_definition |
column_list |
column_name |
column_spec |
comment |
comment_on_statement |
commit_statement |
comp_op |
comparison_predicate |
connect_mode |
connect_option |
connect_statement |
constraint_definition |
constraint_name |
conversion_function |
create_dbproc_statement |
create_domain_statement |
create_function_statement |
create_index_statement |
create_role_statement |
create_schema_statement |
create_sequence_statement |
create_synonym_statement |
create_system_trigger_statement |
create_table_statement |
create_table_temp |
create_trigger_statement |
create_user_statement |
create_usergroup_statement |
create_view_statement |
data_source_name |
data_type |
date_function |
date_or_timestamp_expression |
datetimeformat |
dbfunction_call |
dbfunction_name |
dbproc_name |
declare_cursor_statement |
default_expression |
default_predicate |
default_spec |
delete_rule |
delete_statement |
delimiter_token |
derived_column |
digit |
digit_sequence |
distinct_function |
distinct_spec |
domain_name |
double_quotes |
drop_dbproc_statement |
drop_definition |
drop_domain_statement |
drop_function_statement |
drop_index_statement |
drop_role_statement |
drop_schema_statement |
drop_sequence_statement |
drop_synonym_statement |
drop_system_trigger_statement |
drop_table_statement |
drop_table_temp |
drop_trigger_statement |
drop_user_statement |
drop_usergroup_statement |
drop_view_statement |
duplicates_clause |
equal_or_not |
exists_predicate |
exists_table_statement |
explain_statement |
exponent |
expression |
expression_list |
extended_expression |
extended_letter |
extended_value_spec |
extraction_function |
factor |
fetch_statement |
final_select |
first_character |
first_password_character |
fixed_point_literal |
floating_point_literal |
formal_parameter |
formal_parameter1 |
from_clause |
from_table_spec |
function_spec |
grant_statement |
grant_user_statement |
grant_usergroup_statement |
granted_usergroups |
granted_users |
grantee |
group_clause |
having_clause |
hex_digit |
hex_digit_seq |
hex_literal |
hours |
identifier |
identifier_tail_character |
if_statement |
in_predicate |
index_column_name |
index_name |
index_spec |
indicator_name |
initial_select |
inner_transaction_statement |
insert_expression |
insert_statement |
integer |
internal_oracle |
join_predicate |
join_spec |
joined_table |
key_definition |
key_or_not_null_spec |
key_spec |
keyword |
language_specific_character |
letter |
like_expression |
like_predicate |
limit_clause |
literal |
local_variable |
local_variable_list |
local_variables |
lock_option |
lock_spec |
lock_statement |
mantissa |
mapchar_set_name |
match_char |
match_set |
match_string |
minutes |
modify_column_definition |
modify_definition |
monitor_statement |
new_index_name |
new_password |
new_schema_name |
new_synonym_name |
new_table_name |
new_user_name |
new_usergroup_name |
next_stamp_statement |
not_reserved_keyword |
null_predicate |
numeric_literal |
object_spec |
offset |
old_index_name |
old_password |
old_synonym_name |
old_table_name |
order_clause |
outer_join_indicator |
parameter_name |
parameter_spec |
password |
pattern_element |
position |
predicate |
priv_spec |
privilege |
quantified_predicate |
quantifier |
query_expression |
query_primary |
query_spec |
query_statement |
query_term |
recursive_declare_cursor_statement |
recursive_select |
reference_name |
referenced_column |
referenced_table |
referencing_column |
referential_constraint_definition |
referential_constraint_name |
regular_token |
release_savepoint_statement |
release_statement |
rename_column_statement |
rename_index_statement |
rename_schema_statement |
rename_synonym_statement |
rename_table_statement |
rename_user_statement |
rename_usergroup_statement |
rename_view_statement |
reserved_keyword |
result_column_name |
result_expression |
result_table_name |
revoke_statement |
role_name |
rollback_statement |
rollback_to_statement |
routine |
routine_data_type |
routine_sql_statement |
row_count |
row_spec |
rowno_column |
rowno_predicate |
sample_definition |
savepoint_statement |
scalar_subquery |
schema_authorization_identifier |
schema_element |
schema_name |
schema_name_clause |
schema_priv_spec |
schema_privilege |
search_and_result_spec |
search_condition |
search_expression |
searched_case_function |
searched_case_statement |
searched_case_when_clause |
seconds |
select_column |
select_statement |
sequence_name |
set_function_name |
set_function_spec |
set_insert_clause |
set_statement |
set_update_clause |
sign |
simple_case_function |
simple_case_statement |
simple_case_when_clause |
simple_identifier |
single_select_statement |
sort_spec |
sound_predicate |
source_user |
special_character |
special_function |
special_identifier |
special_identifier_character |
sql_comment |
sql_comment_text |
sql_savepoint_name |
sql_statement |
stamp_column |
statement |
statement_list |
string_function |
string_literal |
string_spec |
subquery |
subtrans_statement |
synonym_name |
table_columns |
table_description_element |
table_expression |
table_name |
term |
time_expression |
time_function |
time_or_timestamp_expression |
token |
top_spec |
trigger_event |
trigger_name |
trigonometric_function |
underscore |
unique_definition |
unlock_statement |
unsigned_integer |
update_clause |
update_statement |
update_statistics_statement |
user_mode |
user_name |
usergroup_mode |
usergroup_name |
value_spec |
variable_name |
vertical_slash |
where_clause |
while_statement |
SQL Syntax Changes |
System Tables |
General Notes |
Database Terms |
Evaluating System Tables (Examples) |
ACTIVECONFIGURATION |
CACHESTATISTICS |
COLUMNS |
CONSTRAINTS |
DATASTATISTICS |
DATAVOLUMES |
DBPROCEDURES |
DBPROCPARAMS |
DOMAINCONSTRAINTS |
DOMAINS |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
FUNCTIONS |
INDEXCOLUMNS |
INDEXES |
INSTANCE |
LOCKS |
LOGQUEUESTATISTICS |
LOGSTATISTICS |
MAPCHARSETS |
ROLEPRIVILEGES |
ROLES |
SEQUENCES |
SESSION_ROLES |
SESSIONS |
SYNONYMS |
TABLEPRIVILEGES |
TABLES |
TRIGGERS |
USERS |
VERSION |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
Definitions of the System Tables |
ACTIVECONFIGURATION |
BACKUPTHREADS |
CACHESTATISTICS |
CATALOGCACHESTATISTICS |
CLASSCONTAINER_CHAINS |
CLASSCONTAINER_KEYS |
CLASSCONTAINER_ROOTS |
CLASSCONTAINERS |
CODEPAGE |
COLUMNS |
COMMANDCACHESTATISTICS |
COMMANDCACHESTATISTICSRESET |
COMMANDMONITOR |
COMMANDSTATISTICS |
COMMANDSTATISTICSRESET |
CONSISTENTVIEWOPENTRANSACTIONS |
CONSISTENTVIEWS |
CONSTRAINTCOLUMNS |
CONSTRAINTS |
CONVERTERMAPPING |
DATACACHE |
DATASOURCEDISTRIBUTIONKEYCOLUMNS |
DATASOURCEPARTIONINGCONDITIONS |
DATASOURCETABLESTATISTICS |
DATASTATISTICS |
DATASTATISTICSRESET |
DATAVOLUMES |
DBPROCEDURES |
DBPROCPARAMS |
DOMAINCONSTRAINTS |
DOMAINS |
FILEDIRECTORIES |
FILES |
FILESYSTEMS |
FOREIGNKEYCOLUMNS |
FOREIGNKEYS |
FREEBLOCKMANAGERBLOCKSTATES |
FREEBLOCKMANAGERSECTIONS |
FREEBLOCKMANAGERSTATISTICS |
FREEBLOCKMANAGERSTATISTICSRESET |
FUNCTIONS |
GARBAGECOLLECTOR_STATISTICS |
HISTORYCLEANUPSTATISTICS |
HISTORYCLEANUPSTATISTICSRESET |
HISTORYINFO |
HOTSTANDBYCOMPONENT |
HOTSTANDBYGROUP |
INDEXCOLUMNS |
INDEXES |
INDEXSIZE |
INDEXSTORAGEDETAILS |
INSTANCE |
IOBUFFERCACHES |
IOJOBS |
IOTHREADSTATISTICS |
IOTHREADSTATISTICSRESET |
LOCKS |
LOCKSTATISTICS |
LOCKSTATISTICSRESET |
LOCK_WAITS |
LOGINFORMATION |
LOGPARTITIONSTATISTICS |
LOGQUEUEINFORMATION |
LOGQUEUESTATISTICS |
LOGQUEUESTATISTICSRESET |
LOGSTATISTICS |
LOGSTATISTICSRESET |
LOGVOLUMES |
MACHINECONFIGURATION |
MACHINEUTILIZATION |
MAPCHARSETS |
MAPSCHEMANAMES |
MEMORYALLOCATORDETAILS |
MEMORYALLOCATORSTATISTICS |
MONITOR |
MONITOR_LOAD |
MONITOR_LOB |
MONITOR_LOCK |
MONITOR_OMS |
MONITOR_PAGES |
MONITOR_REWRITE |
MONITOR_ROW |
MONITOR_TRANS |
MULTIVERSIONREADSTATISTICS |
MULTIVERSIONREADSTATISTICSRESET |
OBJECTLOCKS |
OMSDISCLOSEDCLASSES |
OMSDISCLOSEDCLASSMEMBERS |
OMSLOCKS |
OMSPROCEDURESTATISTICS |
OMSVERSIONS |
OMS_HEAP_STATISTICS |
OMS_VERSIONS |
OPTIMIZERINFORMATION |
PACKAGES |
PAGELOCKS |
POSTUPGRADECHECKLIST |
QUERYREWRITERULES |
REGIONINFORMATION |
REGIONSTATISTICS |
REGIONSTATISTICSRESET |
RESTARTINFORMATION |
ROLEPRIVILEGES |
ROLES |
SCHEMAPRIVILEGES |
SCHEMAS |
SCHEMASIZE |
SEQUENCEPRIVILEGES |
SEQUENCES |
SERVERTASKS |
SESSION_ROLES |
SESSIONS |
SHARELOCKINFORMATION |
SHARELOCKSTATISTICS |
SHARELOCKSTATISTICSRESET |
SHARELOCKWAITINGTASKS |
SNAPSHOTS |
SPINLOCKPOOLSTATISTICS |
SPINLOCKPOOLSTATISTICSRESET |
SPINLOCKSTATISTICS |
SPINLOCKSTATISTICSRESET |
SYNONYMS |
SYSCHECKSTATISTICSDETAILS |
SYSCHECKSTATISTICSLOG |
SYSTEMTRIGGERS |
SYSUPDATECOUNTERWANTED |
SYSUPDSTATLOG |
SYSUPDSTATWANTED |
SYSUPGRADEHISTORY |
TABLEPRIVILEGES |
TABLES |
TABLESIZE |
TABLESTORAGEDETAILS |
TASKGROUPSTATISTICS |
TASKGROUPSTATISTICSRESET |
TASKLOADBALANCINGINFORMATION |
TASKLOADBALANCINGTASKGROUPSTATES |
TASKLOADBALANCINGTASKMOVES |
TRANSACTIONHISTORY |
TRANSACTIONS |
TRANSFORMATIONMODEL |
TRANSFORMATIONMONITOR |
TRANSFORMATIONPACKAGES |
TRANSFORMATIONRESOURCES |
TRANSFORMATIONSTATISTICS |
TRANSFORMATIONSTEPS |
TRIGGERS |
UNLOADEDSTATEMENTS |
USERS |
VERSION |
VIEWCOLUMNS |
VIEWDEFS |
VIEWS |
VIEWTABLES |
Restrictions for SQL Statements |
SQL Mode ORACLE |
SQL Syntax Elements: Differences |
Database Object |
Name |
Namespace |
Access to Objects |
Integer |
Number |
Data Type |
Pseudo Column |
Operator |
Function |
Format |
SQL Statements: Differences |
alter_cluster_statement |
alter_database_statement |
alter_function_statement |
alter_index_statement |
alter_package_statement |
alter_procedure_statement |
alter_profile_statement |
alter_resource_cost_statement |
alter_role_statement |
alter_rollback_segment_statement |
alter_sequence_statement |
alter_snapshot_log_statement |
alter_snapshot_statement |
alter_system_statement |
alter_table_statement |
alter_tablespace_statement |
alter_trigger_statement |
alter_user_statement |
alter_view_statement |
analyze_statement |
audit_statement |
commit_statement |
constraint_clause |
create_cluster_statement |
create_controlfile_statement |
create_database_link_statement |
create_database_statement |
create_index_statement |
create_package_body_statement |
create_package_statement |
create_procedure_statement |
create_profile_statement |
create_rollback_segment_statement |
create_sequence_statement |
create_snapshot_log_statement |
create_snapshot_statement |
create_synonym_statement |
create_table_statement |
create_tablespace_statement |
create_trigger_statement |
create_user_statement |
create_view_statement |
declare_statement |
declare_table_statement |
delete_statement |
describe_statement |
drop_cluster_statement |
drop_database_link_statement |
drop_index_statement |
drop_procedure_statement |
drop_profile_statement |
drop_rollback_segment_statement |
drop_snapshot_log_statement |
drop_snapshot_statement |
drop_table_statement |
drop_tablespace_statement |
drop_trigger_statement |
drop_view_statement |
execute_statement |
explain_plan_statement |
grant_statement |
insert_statement |
lock_table_statement |
noaudit_statement |
rename_statement |
revoke_statement |
rollback_statement |
select_statement |
set_transaction_statement |
truncate_statement |
update_statement |
Errors: Differences |