BNF Index of SQL for Oracle 7
index on key words
index on special characters
sql_command nice to start
applet all the rules in one screen ...
[other languages
BNF]
index of rules
- alias
- allocate_spec
- alter_cluster
- alter_cluster_spec
- alter_command
- alter_cost
- alter_database
- alter_index
- alter_index_spec
- alter_profile
- alter_role
- alter_rollback
- alter_sequence
- alter_sequence_spec
- alter_session
- alter_snapshot
- alter_snapshot_log
- alter_system
- alter_table
- alter_tablespace
- alter_table_spec
- alter_trigger
- alter_user
- alter_user_spec
- alter_view
- analyze_command
- analyze_spec
- archive_log_spec
- audit_command
- audit_object
- audit_sql
- binary_type
- character_type
- char_function
- char_set_name
- cluster_name
- column_constraint
- column_list
- column_name
- comment_command
- comparaison_op
- condition
- connect_clause
- constant
- constraint_list
- controlfile_spec
- conversion_function
- create_cluster
- create_cluster_spec
- create_command
- create_controlfile
- create_database
- create_databaselink
- create_database_spec
- create_index
- create_profile
- create_role
- create_rollback
- create_schema
- create_sequence
- create_sequence_spec
- create_snapshot
- create_snapshot_log
- create_synonym
- create_table
- create_tablespace
- create_trigger
- create_user
- create_user_spec
- create_view
- database_name
- datatype
- date_format
- date_function
- date_type
- decimal_type
- def_column_constraint
- def_table_constraint
- delete_command
- disable_spec
- displayed_column
- distribution_list
- domain_name
- drop_cluster
- drop_command
- drop_databaselink
- drop_index
- drop_profile
- drop_role
- drop_rollback
- drop_sequence
- drop_snapshot
- drop_snapshotlog
- drop_synonym
- drop_table
- drop_tablespace
- drop_trigger
- drop_user
- drop_view
- enable_spec
- explain_command
- expression
- exp_set
- factor
- file_list
- file_name
- file_reuse
- file_reuse_list
- file_spec
- file_spec_list
- file_spec_redo
- float_type
- function
- function_name
- grant_command
- grant_object
- grant_priv
- group_clause
- group_file
- group_file_list
- group_file_spec
- group_function
- identifier
- indexed_column_list
- index_name
- index_storage
- insert_command
- integer_type
- language_name
- link_name
- location_name
- lock_command
- lock_mode
- logfile_clause
- logical_factor
- logical_term
- logmember_clause
- match_string
- modified_column_list
- n
- new_column_list
- new_constraint_list
- new_name
- noaudit_command
- noaudit_object
- noaudit_sql
- number
- number_function
- object_name
- obj_command
- old_name
- order_clause
- other_function
- package_name
- partition_name
- password
- pass_role_list
- privilege
- procedure_name
- profile_name
- profile_spec
- prog_command
- prog_privilege
- quantified_factor
- query
- quoted_string
- recover_clause
- relation_name
- rename_command
- resource_cost_name
- resource_name
- revoke_command
- revoke_object
- revoke_priv
- role_list
- role_list
- rollback_name
- savepoint_name
- schema_name
- selected_table
- select_command
- self
- sequence_command
- sequence_name
- sequence_privilege
- set_clause
- set_role_command
- set_session_spec
- set_transaction_command
- simple_update
- snapshot_command
- snapshot_name
- snapshot_privilege
- sorted_def
- sql_command
- statement_opt
- stat_command
- storage_parameter
- storage_spec
- subquery
- subquery_update
- synonym
- system_priv
- system_spec
- system_status
- tablespace_list
- tablespace_name
- table_command
- table_constraint
- table_name
- table_privilege
- term
- territory_name
- to_control_data
- to_define_data
- to_modify_data
- transaction_command
- trigger_name
- trigger_ref
- trigger_sync
- trigger_when
- truncate_command
- until_spec
- update_clause
- update_command
- user_list
- user_name
- value
- value_list
- variable
- view_command
- view_name
- view_privilege
Jacques Guyot | guyot@cui.unige.ch