| Reference Manual: SAP DB 7.4 |
| Concepts |
| Users and Usergroups |
| Code Attribute |
| UNICODE |
| Code tables |
| ASCII code |
| EBCDIC code |
| Database Catalog/Application Data |
| Database procedure |
| Database Session |
| Data integrity |
| Data Type |
| BOOLEAN |
| Date value |
| LONG column |
| NULL value |
| Special NULL value |
| Number |
| Character string |
| Timestamp value |
| Time value |
| Index |
| Parameter |
| Privilege |
| Role |
| SERIAL |
| Column |
| SQL mode |
| Subtransaction |
| Synonym |
| Table |
| Transaction |
| Trigger |
| Domain |
| Basic Elements |
| Character |
| Digit |
| Letter |
| Extended letter |
| hex_digit |
| language_specific_character |
| Special character |
| Literal (literal) |
| String Literal (string_literal) |
| hex_literal |
| hex_digit_seq |
| Numeric Literal (numeric_literal) |
| Fixed point literal |
| Sign |
| Digit sequence |
| Floating point literal |
| Mantissa |
| Exponent |
| Unsigned integer |
| Integer |
| Token |
| Regular token |
| Keyword |
| Not reserved keyword |
| Reserved keyword |
| Identifier |
| Simple Identifier (simple_identifier) |
| First character |
| Identifier tail character |
| Underscore |
| Double quotes |
| Special Identifier (special_identifier) |
| Delimiter token |
| Names |
| Alias name |
| Usergroup name |
| User name |
| Constraint name |
| Name of a database procedure (dbproc_name) |
| Domain name |
| Owner |
| Result table name |
| Index name |
| Indicator name |
| Mapchar Set Name (mapchar_set_name) |
| Password |
| Parameter name |
| Privilege type (privilege) |
| Name of a referential constraint (referential_constraint_name) |
| Reference name |
| Role Name (role_name) |
| Sequence name |
| Column name |
| Synonym name |
| Table name |
| Trigger Name (trigger_name) |
| Column specification (column_spec) |
| Parameter specification (parameter spec) |
| Specifying values (extended value spec) |
| Specifying Values (value_spec) |
| Date and time format (datetimeformat) |
| Specifying a string (string spec) |
| Specifying a Key (key_spec) |
| Expression |
| factor |
| Predicate (predicate) |
| BETWEEN predicate (between_predicate) |
| Boolean predicate (bool_predicate) |
| Comparison Predicate (comparison_predicate) |
| Comparison operators (comp_op) |
| Comparison operators (equal_or_not) |
| DEFAULT predicate |
| EXISTS Predicate (exists_predicate) |
| IN Predicate (in_predicate) |
| JOIN Predicate (join_predicate) |
| LIKE Predicate (like_predicate) |
| Pattern element |
| match_string |
| match_set |
| NULL predicate |
| Quantified Predicate (quantified_predicate) |
| Quantifier |
| ROWNO Predicate (rowno_predicate) |
| SOUNDS predicate |
| Search Condition (search_condition) |
| Boolean factor |
| Functions: Overview |
| Function (function_spec) |
| Arithmetic function |
| ABS(a) |
| CEIL(a) |
| EXP(a) |
| FIXED(a,p,s) |
| FLOAT(a,s) |
| FLOOR(a) |
| INDEX(a,b,p,s) |
| LENGTH(a) |
| LN(a) |
| LOG(a,b) |
| NOROUND(a) |
| PI |
| POWER(a,n) |
| ROUND(a,n) |
| SIGN(a) |
| SQRT(a) |
| TRUNC(a,n) |
| Trigonometric function |
| String Function (string_function) |
| ALPHA(x,n) |
| ASCII/EBCDIC(x) |
| EXPAND(x,n) |
| GET_OBJECTNAME(x,o) |
| GET_OWNER(x,o) |
| 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) |
| SUBSTR(x,a,b) |
| TRANSLATE(x,y,z) |
| TRIM(x,y) |
| UPPER/LOWER(x) |
| Concatenation (concatenation) |
| Date function |
| ADDDATE/SUBDATE(t,a) |
| DATEDIFF(t,s) |
| DAYNAME/MONTHNAME(t) |
| DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
| MAKEDATE(a,b) |
| date_or_timestamp_expression |
| Time function |
| ADDTIME/SUBTIME(t,a) |
| MAKETIME(h,m,s) |
| TIMEDIFF(t,s) |
| hours/minutes/seconds |
| Time expression |
| Time or timestamp expression |
| 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) |
| Conversion Function (conversion_function) |
| CHAR(a,t) |
| CHR(a,n) |
| HEX(a) |
| HEXTORAW(a) |
| NUM(a) |
| Set Function (set_function_spec) |
| DISTINCT Function (distinct_function) |
| ALL function |
| Set function name |
| AVG |
| COUNT |
| MAX/MIN |
| STDDEV |
| SUM |
| VARIANCE |
| SQL Statement: Overview |
| Comment (sql_comment) |
| Example Tables |
| customer |
| hotel |
| room |
| reservation |
| Data definition |
| CREATE TABLE Statement (create_table_statement) |
| SAMPLE definition |
| Column Definition (column_definition) |
| Data Type (data_type) |
| CHAR[ACTER] |
| VARCHAR |
| LONG[VARCHAR] |
| BOOLEAN |
| FIXED |
| FLOAT |
| INT[EGER] |
| SMALLINT |
| DATE |
| TIME |
| TIMESTAMP |
| Memory requirements of a column value per data types |
| Column Attributes (column_attributes) |
| DEFAULT Specification (default_spec) |
| CONSTRAINT definition (constraint_definition) |
| Referential CONSTRAINT definition (referential_constraint_defini |
| DELETE rule |
| CASCADE dependency |
| Reference cycle |
| Matching row |
| Key Definition (key_definition) |
| UNIQUE Definition (unique_definition) |
| DROP TABLE statement |
| CASCADE option |
| ALTER TABLE statement |
| ADD Definition (add_definition) |
| ALTER definition |
| COLUMN change definition |
| DROP definition |
| MODIFY definition |
| RENAME TABLE statement |
| RENAME COLUMN statement |
| EXISTS TABLE statement |
| CREATE DOMAIN statement |
| DROP DOMAIN statement |
| CREATE SEQUENCE Statement (create_sequence_statement) |
| DROP SEQUENCE statement |
| CREATE SYNONYM statement |
| DROP SYNONYM statement |
| RENAME SYNONYM statement |
| CREATE VIEW Statement (create_view_statement) |
| Complex view table |
| Updateable View Table |
| INSERT privilege for the owner of the view table |
| UPDATE privilege for the owner of the view table |
| DELETE privilege for the owner of the view table |
| Updateable join view table |
| DROP 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 |
| COMMENT ON Statement (comment_on_statement) |
| CREATE DBPROC Statement (create_dbproc_statement) |
| routine |
| statement |
| General CASE Statement (searched_case_statement) |
| Simple CASE Statement (simple_case_statement) |
| DROP DBPROC statement |
| CREATE TRIGGER Statement (create_trigger_statement) |
| DROP TRIGGER statement |
| Authorization |
| CREATE USER Statement (create_user_statement) |
| User mode |
| CREATE USERGROUP Statement (create_usergroup_statement) |
| Usergroup name |
| DROP USER statement |
| DROP USERGROUP statement |
| ALTER USER Statement (alter_user_statement) |
| ALTER USERGROUP Statement (alter_usergroup_statement) |
| RENAME USER statement |
| RENAME USERGROUP statement |
| GRANT USER Statement (grant_user_statement) |
| GRANT USERGROUP Statement (grant_usergroup_statement) |
| ALTER PASSWORD statement |
| CREATE ROLE Statement (create_role_statement) |
| DROP ROLE Statement (drop_role_statement) |
| GRANT Statement (grant_statement) |
| Privilege specification (priv_spec) |
| grantee |
| REVOKE Statement (revoke_statement) |
| Data Manipulation |
| INSERT Statement (insert_statement) |
| Data type of the target column and inserted value |
| Join View Table in INSERT Statement |
| QUERY Expression in INSERT Statement |
| DUPLICATES clause |
| Constraint Definition in INSERT Statement |
| Trigger in INSERT Statement |
| Extended expression |
| SET INSERT clause |
| UPDATE Statement |
| SET UPDATE clause |
| Column combination for a given column of a join view table |
| DELETE statement |
| NEXT STAMP statement |
| CALL Statement (call_statement) |
| Data Query |
| QUERY statement |
| Named/Unnamed Result Table |
| DECLARE CURSOR statement |
| Recursive DECLARE CURSOR statement |
| SELECT Statement (named_select_statement) |
| SELECT Statement (select_statement) |
| QUERY expression (query expression) |
| QUERY term (query_term) |
| QUERY expression (named query expression) |
| QUERY term (named query term) |
| QUERY specification (query_spec) |
| DISTINCT function (distinct spec) |
| Selected Column (select_column) |
| QUERY specification (named_query_spec) |
| Table expression |
| FROM clause |
| FROM TABLE specification (from_table_spec) |
| joined_table |
| WHERE Clause (where_clause) |
| GROUP Clause (group_clause) |
| HAVING clause |
| Subquery |
| Correlated Subquery |
| Scalar Subquery (scalar_subquery) |
| ORDER Clause (order_clause) |
| UPDATE Clause (update_clause) |
| LOCK Option (lock_option) |
| OPEN CURSOR statement |
| FETCH statement |
| CLOSE statement |
| SINGLE SELECT statement |
| EXPLAIN Statement (explain_statement) |
| Transaction |
| CONNECT Statement (connect_statement) |
| SET Statement (set_statement) |
| COMMIT Statement (commit_statement) |
| ROLLBACK Statement (rollback_statement) |
| SUBTRANS Statement (subtrans_statement) |
| LOCK Statement(lock_statement) |
| ROW specification (row spec) |
| UNLOCK Statement (unlock_statement) |
| RELEASE Statement (release_statement) |
| Statistics |
| UPDATE STATISTICS Statement (update_statistics_statement) |
| MONITOR Statement (monitor_statement) |
| Restrictions |
| Syntax List |
| Syntax Notation |
| add_definition |
| alias_name |
| all_function |
| alter_definition |
| alter_index_statement |
| alter_password_statement |
| alter_table_statement |
| alter_user_statement |
| alter_usergroup_statement |
| argument |
| arithmetic_function |
| assignment_statement |
| between_predicate |
| bool_predicate |
| boolean_factor |
| boolean_term |
| call_statement |
| cascade_option |
| case_else_clause |
| case_function |
| case_statement |
| character |
| 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_option |
| connect_statement |
| constraint_definition |
| constraint_name |
| conversion_function |
| create_dbproc_statement |
| create_domain_statement |
| create_index_statement |
| create_role_statement |
| create_sequence_statement |
| create_synonym_statement |
| create_table_statement |
| create_table_temp |
| create_trigger_statement |
| create_user_statement |
| create_usergroup_statement |
| create_view_statement |
| data_type |
| date_function |
| date_or_timestamp_expression |
| datetimeformat |
| dbproc_name |
| declare_cursor_statement |
| 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_index_statement |
| drop_role_statement |
| drop_sequence_statement |
| drop_synonym_statement |
| drop_table_statement |
| 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 |
| 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_name |
| indicator_name |
| initial_select |
| insert_expression |
| insert_statement |
| integer |
| join_predicate |
| join_spec |
| joined_table |
| key_definition |
| key_or_not_null_spec |
| key_spec |
| key_word |
| language_specific_character |
| letter |
| like_expression |
| like_predicate |
| 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_definition |
| monitor_statement |
| named_query_expression |
| named_query_primary |
| named_query_spec |
| named_query_term |
| named_select_statement |
| new_index_name |
| new_table_name |
| next_stamp_statement |
| not_reserved_key_word |
| null_predicate |
| numeric_literal |
| object_spec |
| old_index_name |
| old_table_name |
| open_cursor_statement |
| order_clause |
| outer_join_inidicator |
| owner |
| parameter_name |
| parameter_spec |
| password |
| pattern_element |
| position |
| predicate |
| priv_spec |
| privilege |
| procedure_name |
| 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_statement |
| rename_column_statement |
| rename_index_statement |
| rename_synonym_statement |
| rename_table_statement |
| rename_user_statement |
| rename_usergroup_statement |
| rename_view_statement |
| reserved_key_word |
| result_column_name |
| result_table_name |
| revoke_statement |
| role_name |
| rollback_statement |
| routine |
| routine_sql_statement |
| row_spec |
| rowno_column |
| rowno_predicate |
| sample_definition |
| scalar_subquery |
| search_and_result_spec |
| search_condition |
| 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 |
| 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_or_timestamp_expression |
| time_function |
| 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 |
| where_clause |
| while_statement |