SQL Syntax 4.6 Release¶
The EBNF and Railroad Diagrams for JSQLParser-4.6.
Statement¶
::= ( 'IF' Condition ( ( SingleStatement | Block ) ST_SEMICOLON? 'ELSE' )? )? ( SingleStatement | Block ) ST_SEMICOLON? EOF
|
Not referenced by any.
|
SingleStatement¶
| Select
| Upsert
| Alter
| Create
| Drop
| Analyze
| Truncate
| Execute
| Set
| Reset
| Show
| Use
| 'COMMIT'
| Comment
| Describe
| Explain
| Declare
| Grant
|
Referenced by:
|
Block¶
Referenced by:
|
Statements¶
::= ST_SEMICOLON* ( 'IF' Condition ( SingleStatement | Block ) ( ST_SEMICOLON? 'ELSE' ( SingleStatement | Block ) )? | SingleStatement | Block ST_SEMICOLON? | UnsupportedStatement ) ( ST_SEMICOLON ( 'IF' Condition ( SingleStatement | Block ) ( ST_SEMICOLON? 'ELSE' ( SingleStatement | Block ) )? | SingleStatement | Block ST_SEMICOLON? | UnsupportedStatement )? )* EOF |
Not referenced by any.
|
Declare¶
Declare ::= 'DECLARE' UserVariable ( 'TABLE' '(' ColumnDefinition ( ',' ColumnDefinition )* ')' | 'AS' RelObjectName | ColDataType ( '=' Expression )? ( ',' UserVariable ColDataType ( '=' Expression )? )* ) |
Referenced by:
|
Set¶
Set ::= 'SET' ( 'LOCAL' | 'SESSION' )? ( K_DATETIMELITERAL 'ZONE' | ( UserVariable | IdentifierChain ) '='? ) Expression ( ',' ( K_DATETIMELITERAL 'ZONE' | RelObjectNameExt '='? )? Expression )* |
Referenced by:
|
Reset¶
Referenced by:
|
RenameTableStatement¶
Referenced by:
|
PurgeStatement¶
::= 'PURGE' ( 'TABLE' Table | 'INDEX' Index | 'RECYCLEBIN' | 'DBA_RECYCLEBIN' | 'TABLESPACE' S_IDENTIFIER ( 'USER' S_IDENTIFIER )? ) |
Referenced by:
|
Describe¶
Referenced by:
|
Explain¶
Referenced by:
|
ExplainOptionBoolean¶
::= ( 'TRUE' | 'FALSE' | 'ON' | 'OFF' )? |
Referenced by:
|
ExplainFormatOption¶
::= ( 'XML' | 'JSON' | 'YAML' )? |
Referenced by:
|
ExplainStatementOptions¶
::= ( ( 'ANALYZE' | 'BUFFERS' | 'COSTS' | 'VERBOSE' ) ExplainOptionBoolean | 'FORMAT' ExplainFormatOption )* |
Referenced by:
|
Use¶
Use ::= 'USE' 'SCHEMA'? RelObjectNameExt |
Referenced by:
|
Show¶
Referenced by:
|
ShowColumns¶
::= 'COLUMNS' 'FROM' RelObjectNameExt |
Referenced by:
|
ShowIndex¶
::= 'INDEX' 'FROM' RelObjectNameExt |
Referenced by:
|
ShowTables¶
::= 'EXTENDED'? 'FULL'? 'TABLES' ( ( 'FROM' | 'IN' ) RelObjectNameExt )? ( 'LIKE' SimpleExpression | 'WHERE' Expression )? |
Referenced by:
|
Values¶
Values ::= ( 'VALUES' | 'VALUE' ) ExpressionList |
Referenced by:
|
ReturningClause¶
::= ( 'RETURNING' | 'RETURN' ) SelectItemsList ( 'INTO' ( Table | UserVariable ) ( ',' ( Table | UserVariable ) )* )? |
Update¶
Update ::= 'UPDATE' 'LOW_PRIORITY'? 'IGNORE'? TableWithAlias JoinsList? 'SET' UpdateSets OutputClause? ( 'FROM' FromItem JoinsList? )? WhereClause? OrderByElements? PlainLimit? ReturningClause? |
Referenced by:
|
UpdateSets¶
::= ( Column '=' Expression | ParenthesedExpressionList '=' ( ParenthesedSelect | ParenthesedExpressionList ) ) ( ',' Column '=' Expression | ParenthesedExpressionList '=' ( ParenthesedSelect | ParenthesedExpressionList ) )* |
Referenced by:
|
Insert¶
Insert ::= 'INSERT' ( 'LOW_PRIORITY' | 'DELAYED' | 'HIGH_PRIORITY' )? 'IGNORE'? 'INTO'?
Table ( 'AS'? RelObjectNameWithoutValue )? ( '(' ColumnList ')' )? OutputClause? ( 'SET' UpdateSets | Select ) ( 'ON' 'DUPLICATE' 'KEY' 'UPDATE' UpdateSets )? ( 'ON' 'CONFLICT' InsertConflictTarget? InsertConflictAction )? ReturningClause? |
Referenced by:
|
InsertConflictTarget¶
| 'ON' 'CONSTRAINT' RelObjectNameExt2 |
Referenced by:
|
InsertConflictAction¶
::= 'DO' ( 'NOTHING' | 'UPDATE' 'SET' UpdateSets WhereClause? ) |
Referenced by:
|
OutputClause¶
Upsert¶
Upsert ::= ( 'UPSERT' | ( 'INSERT' 'OR' )? 'REPLACE' ) 'INTO'? Table ParenthesedColumnList? ( 'SET' UpdateSets | Select ) ( 'ON' 'DUPLICATE' 'KEY' 'UPDATE' UpdateSets )? |
Referenced by:
|
Delete¶
Delete ::= 'DELETE' 'LOW_PRIORITY'? 'QUICK'? 'IGNORE'? ( ( TableWithAlias ( ',' TableWithAlias )* OutputClause? )? 'FROM' )? ( TableWithAlias JoinsList? )? ( 'USING' TableWithAlias ( ',' TableWithAlias )* )? WhereClause? OrderByElements? PlainLimit? ReturningClause? |
Referenced by:
|
Merge¶
Merge ::= 'MERGE' 'INTO' TableWithAlias 'USING' FromItem 'ON' '(' Expression ')' ( MergeUpdateClause MergeInsertClause? | MergeInsertClause MergeUpdateClause? )? |
Referenced by:
|
MergeUpdateClause¶
::= 'WHEN' 'MATCHED' 'THEN' 'UPDATE' 'SET' UpdateSets ( 'WHERE' Expression )? ( 'DELETE' 'WHERE' Expression )? |
Referenced by:
|
MergeInsertClause¶
::= 'WHEN' 'NOT' 'MATCHED' 'THEN' 'INSERT' ( '(' ColumnList ')' )? 'VALUES' '(' SimpleExpressionList ')' ( 'WHERE' Expression )? |
Referenced by:
|
RelObjectNameList¶
::= RelObjectNameExt ( ( '.' | ':' ) '.'* RelObjectNameExt2 )* |
Column¶
RelObjectNameWithoutValue¶
::= S_IDENTIFIER
| 'ACTION'
| 'ACTIVE'
| 'ADD'
| 'ADVANCE'
| 'ADVISE'
| 'AGAINST'
| 'ALGORITHM'
| 'ALTER'
| 'ANALYZE'
| 'APPLY'
| 'ARCHIVE'
| 'ARRAY'
| 'ASC'
| 'AT'
| 'AUTHORIZATION'
| 'AUTO'
| 'BEGIN'
| 'BINARY'
| 'BIT'
| 'BUFFERS'
| 'BY'
| 'BYTE'
| 'BYTES'
| 'CACHE'
| 'CALL'
| 'CASCADE'
| 'CASE'
| 'CAST'
| 'CHANGE'
| 'CHANGES'
| 'CHAR'
| 'CHARACTER'
| 'CHECKPOINT'
| 'CLOSE'
| 'COLLATE'
| 'COLUMN'
| 'COLUMNS'
| 'COMMENT'
| 'COMMIT'
| 'CONFLICT'
| 'CONVERT'
| 'COSTS'
| 'CS'
| 'CYCLE'
| 'DATABASE'
| 'DDL'
| 'DECLARE'
| 'DEFAULT'
| 'DEFERRABLE'
| 'DELAYED'
| 'DELETE'
| 'DESC'
| 'DESCRIBE'
| 'DISABLE'
| 'DISCONNECT'
| 'DIV'
| 'DML'
| 'DO'
| 'DOMAIN'
| 'DROP'
| 'DUMP'
| 'DUPLICATE'
| 'EMIT'
| 'ENABLE'
| 'END'
| 'ESCAPE'
| 'EXCLUDE'
| 'EXEC'
| 'EXECUTE'
| 'EXPLAIN'
| 'EXTENDED'
| 'EXTRACT'
| 'FALSE'
| 'FILTER'
| 'FIRST'
| 'FLUSH'
| 'FN'
| 'FOLLOWING'
| 'FORMAT'
| 'FULLTEXT'
| 'FUNCTION'
| 'GLOBAL'
| 'GRANT'
| 'GUARD'
| 'HISTORY'
| 'HOPPING'
| 'INCLUDE'
| 'INCREMENT'
| 'INDEX'
| 'INSERT'
| 'INTERLEAVE'
| 'ISNULL'
| 'JSON'
| 'KEEP'
| 'KEY'
| 'KEYS'
| 'LAST'
| 'LEADING'
| 'LINK'
| 'LOCAL'
| 'LOCKED'
| 'LOG'
| 'MATCH'
| 'MATCHED'
| 'MATERIALIZED'
| 'MAXVALUE'
| 'MEMBER'
| 'MERGE'
| 'MINVALUE'
| 'MODIFY'
| 'MOVEMENT'
| 'NEXT'
| 'NO'
| 'NOCACHE'
| 'NOKEEP'
| 'NOLOCK'
| 'NOMAXVALUE'
| 'NOMINVALUE'
| 'NOORDER'
| 'NOTHING'
| 'NOVALIDATE'
| 'NOWAIT'
| 'NULLS'
| 'OF'
| 'OFF'
| 'OPEN'
| 'OVER'
| 'OVERLAPS'
| 'PARALLEL'
| 'PARENT'
| 'PARTITION'
| 'PATH'
| 'PERCENT'
| 'PLACING'
| 'PRECEDING'
| 'PRECISION'
| 'PRIMARY'
| 'PRIOR'
| 'PURGE'
| 'QUERY'
| 'QUICK'
| 'QUIESCE'
| 'RANGE'
| 'READ'
| 'RECYCLEBIN'
| 'REFERENCES'
| 'REFRESH'
| 'REGISTER'
| 'RENAME'
| 'REPLACE'
| 'RESET'
| 'RESTART'
| 'RESTRICT'
| 'RESTRICTED'
| 'RESUMABLE'
| 'RESUME'
| 'RLIKE'
| 'ROLLBACK'
| 'ROW'
| 'ROWS'
| 'RR'
| 'RS'
| 'SAVEPOINT'
| 'SCHEMA'
| 'SEPARATOR'
| 'SEQUENCE'
| 'SESSION'
| 'SETS'
| 'SHOW'
| 'SHUTDOWN'
| 'SIBLINGS'
| 'SIGNED'
| 'SIMILAR'
| 'SIZE'
| 'SKIP'
| 'STORED'
| 'STRING'
| 'SUSPEND'
| 'SWITCH'
| 'SYNONYM'
| 'SYSTEM'
| 'TABLE'
| 'TABLESPACE'
| 'TEMP'
| 'TEMPORARY'
| 'THEN'
| 'TIMEOUT'
| 'TIMESTAMPTZ'
| 'TO'
| 'TRIGGER'
| 'TRUE'
| 'TRUNCATE'
| 'TUMBLING'
| 'TYPE'
| 'UNLOGGED'
| 'UNQIESCE'
| 'UNSIGNED'
| 'UPDATE'
| 'UPSERT'
| 'UR'
| 'USER'
| 'VALIDATE'
| 'VERBOSE'
| 'VIEW'
| 'WAIT'
| 'WITHIN'
| 'WITHOUT'
| 'WORK'
| 'XML'
| 'XMLAGG'
| 'XMLTEXT'
| 'YAML'
| 'YES'
| 'ZONE' |
RelObjectName¶
| 'GROUP'
| 'INTERVAL'
| 'ON'
| 'START'
| 'TOP'
| 'VALUE'
| 'VALUES'
| 'CREATE'
| 'TABLES'
| 'CONNECT'
| 'IGNORE' |
Referenced by:
|
RelObjectNameWithoutStart¶
| 'TOP'
| 'VALUE'
| 'VALUES'
| 'INTERVAL' |
Referenced by:
|
RelObjectNameExt¶
::= RelObjectName
| 'ALL'
| 'ANY'
| 'SOME'
| 'LEFT'
| 'RIGHT'
| 'SET'
| 'DOUBLE'
| 'IF'
| 'IIF'
| 'OPTIMIZE'
| 'LIMIT'
| 'OFFSET'
| 'PROCEDURE'
| 'PUBLIC'
| 'CASEWHEN'
| 'IN'
| 'GROUPING'
| 'ORDER' |
RelObjectNameExt2¶
::= RelObjectNameExt
| 'FROM'
| K_SELECT
| 'CURRENT' |
Table¶
TableWithAlias¶
SelectWithWithItems¶
::= Select |
Referenced by:
|
Select¶
ParenthesedSelect¶
::= '(' Select ')' |
LateralView¶
Referenced by:
|
LateralViews¶
::= LateralView+ |
Referenced by:
|
LateralSubSelect¶
::= 'LATERAL' '(' Select ')' |
Referenced by:
|
PlainSelect¶
::= K_SELECT 'STRAIGHT_JOIN'? Skip? First? ( 'ALL' | 'DISTINCT' ( 'ON' '(' SelectItemsList ')' )? | 'UNIQUE' | 'SQL_CALC_FOUND_ROWS' | 'SQL_NO_CACHE' | 'SQL_CACHE' )? Top? SelectItemsList IntoClause? ( 'FROM' FromItem LateralViews? JoinsList? )? 'FINAL'? KSQLWindowClause? WhereClause? OracleHierarchicalQueryClause? Having? GroupByColumnReferences? Having? OrderByElements? ( 'WINDOW' RelObjectName 'AS' windowDefinition ( ',' RelObjectName 'AS' windowDefinition )* )? OrderByElements? ( 'EMIT' 'CHANGES' )? LimitBy? LimitWithOffset? Offset? LimitWithOffset? Fetch? WithIsolation? ( 'FOR' 'UPDATE' ( 'OF' Table )? Wait? ( 'NOWAIT' | 'SKIP' 'LOCKED' )? )? OptimizeFor? ( 'FOR' 'XML' 'PATH' '(' S_CHAR_LITERAL ')' )? |
Referenced by:
|
SetOperationList¶
::= ( ( 'UNION' ( 'ALL' | 'DISTINCT' )? | 'INTERSECT' | 'MINUS' | 'EXCEPT'
) ( PlainSelect | Values | ParenthesedSelect ) )+ OrderByElements? LimitWithOffset? Offset? LimitWithOffset? Fetch? WithIsolation? |
Referenced by:
|
WithList¶
Referenced by:
|
WithItem¶
Referenced by:
|
SelectItemsList¶
::= SelectItem ( ',' SelectItem )* |
SelectItem¶
Referenced by:
|
AllTableColumns¶
::= Table '.' '*' |
Referenced by:
|
Alias¶
Alias ::= 'AS'? ( RelObjectNameWithoutStart | S_CHAR_LITERAL ) ( '(' RelObjectName ColDataType? ( ',' RelObjectName ColDataType? )* ')' )? |
SQLServerHint¶
::= 'INDEX' '(' RelObjectName ')'
| 'NOLOCK' |
Referenced by:
|
SQLServerHints¶
::= 'WITH' '(' SQLServerHint ( ',' SQLServerHint )* ')' |
Referenced by:
|
MySQLIndexHint¶
::= ( 'USE' | 'SHOW' | 'IGNORE' | 'FORCE' ) ( 'INDEX' | 'KEY' ) '(' RelObjectNameWithoutValue ( ',' RelObjectNameWithoutValue )* ')' |
Referenced by:
|
FunctionItem¶
Referenced by:
|
PivotForColumns¶
| Column |
PivotFunctionItems¶
::= FunctionItem ( ',' FunctionItem )* |
ExpressionListItem¶
Referenced by:
|
PivotMultiInItems¶
::= ExpressionListItem ( ',' ExpressionListItem )* |
Pivot¶
Pivot ::= 'PIVOT' '(' PivotFunctionItems 'FOR' PivotForColumns 'IN' '(' ( SelectItemsList | PivotMultiInItems ) ')' ')' Alias? |
Referenced by:
|
PivotXml¶
PivotXml ::= 'PIVOT' 'XML' '(' PivotFunctionItems 'FOR' PivotForColumns 'IN' '(' ( 'ANY' | Select | SelectItemsList | PivotMultiInItems ) ')' ')' |
Referenced by:
|
UnPivot¶
UnPivot ::= 'UNPIVOT' ( ( 'INCLUDE' | 'EXCLUDE' ) 'NULLS' )? '(' PivotForColumns 'FOR' PivotForColumns 'IN' '(' SelectItemsList ')' ')' Alias? |
Referenced by:
|
IntoClause¶
Referenced by:
|
ParenthesedFromItem¶
Referenced by:
|
FromItem¶
FromItem ::= ( TableFunction | Table | ParenthesedFromItem | ParenthesedSelect Pivot? UnPivot? | LateralSubSelect ) Alias? UnPivot? ( PivotXml | Pivot )? ( MySQLIndexHint | SQLServerHints )? |
Referenced by:
|
JoinsList¶
::= JoinerExpression+ |
Referenced by:
|
JoinerExpression¶
::= 'GLOBAL'? 'NATURAL'? ( ( 'RIGHT' | 'FULL' )? 'OUTER'? | 'LEFT' ( 'SEMI'
| 'OUTER' )? | 'INNER' | 'CROSS' ) ( 'JOIN' | ',' 'OUTER'? | 'STRAIGHT_JOIN' | 'APPLY'
) FromItem ( ( 'WITHIN' '(' JoinWindow ')' )? ( 'ON' Expression )+ | 'USING' '(' Column ( ',' Column )* ')' )? |
Referenced by:
|
JoinWindow¶
Referenced by:
|
KSQLWindowClause¶
::= 'WINDOW' ( 'HOPPING' '(' 'SIZE' S_LONG S_IDENTIFIER ',' 'ADVANCE' 'BY' | 'SESSION' '(' | 'TUMBLING' '(' 'SIZE' ) S_LONG S_IDENTIFIER ')' |
Referenced by:
|
WhereClause¶
::= 'WHERE' Expression |
OracleHierarchicalQueryClause¶
::= ( 'START' 'WITH' AndExpression 'CONNECT' 'BY' 'NOCYCLE'? | 'CONNECT' 'BY' 'NOCYCLE'? ( AndExpression 'START' 'WITH' )? ) AndExpression |
Referenced by:
|
GroupByColumnReferences¶
::= 'GROUP' 'BY' ( 'GROUPING' 'SETS' '(' GroupingSet ( ',' GroupingSet )* ')' | ExpressionList ( 'GROUPING' 'SETS' '(' GroupingSet ( ',' GroupingSet )* ')' )? ) |
Referenced by:
|
GroupingSet¶
Referenced by:
|
Having¶
Having ::= 'HAVING' Expression |
Referenced by:
|
OrderByElements¶
::= 'ORDER' 'SIBLINGS'? 'BY' OrderByElement ( ',' OrderByElement )* |
OrderByElement¶
::= Expression ( 'ASC' | 'DESC' )? ( 'NULLS' ( 'FIRST' | 'LAST' )? )? |
Referenced by:
|
SimpleJdbcParameter¶
::= '?' S_LONG? |
SimpleJdbcNamedParameter¶
::= ':' RelObjectNameExt |
Referenced by:
|
LimitWithOffset¶
::= 'LIMIT' Expression ',' Expression
|
Referenced by:
|
PlainLimit¶
::= 'LIMIT' ( ParenthesedSelect | Expression ) |
Referenced by:
|
LimitBy¶
Referenced by:
|
Offset¶
Offset ::= 'OFFSET' Expression ( 'ROWS' | 'ROW' )? |
Referenced by:
|
Fetch¶
Fetch ::= 'FETCH' ( 'FIRST' | 'NEXT' ) Expression ( 'ROWS' | 'ROW' ) 'ONLY' |
Referenced by:
|
WithIsolation¶
::= 'WITH' K_ISOLATION |
Referenced by:
|
OptimizeFor¶
::= 'OPTIMIZE' 'FOR' S_LONG 'ROWS' |
Referenced by:
|
Top¶
Top ::= 'TOP' ( S_LONG | SimpleJdbcParameter | ':' S_IDENTIFIER? | '(' AdditiveExpression ')' ) 'PERCENT'? 'WITH TIES'? |
Referenced by:
|
Skip¶
Referenced by:
|
First¶
Referenced by:
|
Expression¶
XorExpression¶
::= OrExpression ( 'XOR' OrExpression )* |
Referenced by:
|
OrExpression¶
::= AndExpression ( 'OR' AndExpression )* |
Referenced by:
|
AndExpression¶
::= ( Condition | ( 'NOT' | '!' )? '(' XorExpression ')' ) ( ( 'AND' | '&&' ) ( Condition | ( 'NOT' | '!' )? '(' XorExpression ')' ) )* |
Referenced by:
|
Condition¶
::= ( 'NOT' | '!' )? ( RegularCondition | SQLCondition ) |
Referenced by:
|
OverlapsCondition¶
::= ParenthesedExpressionList 'OVERLAPS' ParenthesedExpressionList |
Referenced by:
|
RegularCondition¶
::= 'PRIOR'? ComparisonItem ( '(' '+' ')' )? ( '>' | '<' | '=' | OP_GREATERTHANEQUALS | OP_MINORTHANEQUALS | OP_NOTEQUALSSTANDARD | OP_NOTEQUALSBANG | '@@' | '~' | ( 'NOT'? 'REGEXP' | 'RLIKE' ) 'BINARY'? | '~*' | '!~' | '!~*' | '@>'
| '<@' | '?' | '?|' | '?&' | OP_CONCAT | '-' | '-#' | '<->' | '<#>' ) 'PRIOR'? ComparisonItem ( '(' '+' ')' )? |
Referenced by:
|
SQLCondition¶
::= ExistsExpression
|
Referenced by:
|
InExpression¶
::= SimpleExpression ( '(' '+' ')' )? 'NOT'? 'IN' ( S_CHAR_LITERAL | Function | ParenthesedSelect | ParenthesedExpressionList | SimpleExpression ) |
Referenced by:
|
Between¶
Referenced by:
|
LikeExpression¶
Referenced by:
|
SimilarToExpression¶
::= 'NOT'? 'SIMILAR' 'TO' SimpleExpression ( 'ESCAPE' S_CHAR_LITERAL )? |
Referenced by:
|
IsDistinctExpression¶
::= 'IS' 'NOT'? 'DISTINCT' 'FROM' SimpleExpression |
Referenced by:
|
IsNullExpression¶
::= 'ISNULL'
| 'IS' 'NOT'? 'NULL' |
Referenced by:
|
IsBooleanExpression¶
::= 'IS' 'NOT'? ( 'TRUE' | 'FALSE' ) |
Referenced by:
|
ExistsExpression¶
::= 'EXISTS' SimpleExpression |
Referenced by:
|
MemberOfExpression¶
::= 'MEMBER' 'OF' Expression |
Referenced by:
|
ExpressionList¶
ParenthesedExpressionList¶
::= '(' ( ComplexExpressionList | SimpleExpressionList )? ')' |
SimpleExpressionList¶
::= SimpleExpression ( ',' SimpleExpression )* |
Referenced by:
|
ColumnList¶
Referenced by:
|
ParenthesedColumnList¶
::= '(' ColumnList ')' |
Referenced by:
|
ComplexExpressionList¶
::= ( OracleNamedFunctionParameter | Expression ) ( ',' ( OracleNamedFunctionParameter | Expression ) )* |
NamedExpressionListExprFirst¶
::= SimpleExpression ( 'FROM' | 'IN' | 'PLACING' ) SimpleExpression ( ( 'FOR' | 'FROM' ) SimpleExpression ( 'FOR' SimpleExpression )? )? |
Referenced by:
|
ComparisonItem¶
Referenced by:
|
AnyComparisonExpression¶
::= ( 'ANY' | 'SOME' | 'ALL' ) Select |
Referenced by:
|
SimpleExpression¶
ConcatExpression¶
Referenced by:
|
BitwiseAndOr¶
::= AdditiveExpression ( ( '|' | '&' | '<<' | '>>' ) AdditiveExpression )* |
Referenced by:
|
AdditiveExpression¶
::= MultiplicativeExpression ( ( '+' | '-' ) MultiplicativeExpression )* |
Referenced by:
|
MultiplicativeExpression¶
::= BitwiseXor ( ( '*' | '/' | 'DIV' | '%' ) BitwiseXor )* |
Referenced by:
|
BitwiseXor¶
::= PrimaryExpression ( '^' PrimaryExpression )* |
Referenced by:
|
ArrayExpression¶
::= ( '[' SimpleExpression? ( ':' SimpleExpression? )? ']' )+ |
Referenced by:
|
PrimaryExpression¶
::= ( 'NOT' | '!' )? ( '+' | '-' | '~' )? ( 'NULL' | CaseWhenExpression | SimpleJdbcParameter | JdbcNamedParameter | UserVariable | NumericBind | ExtractExpression | MySQLGroupConcat | XMLSerializeExpr | JsonExpression | JsonFunction | JsonAggregateFunction | FullTextSearch | Function AnalyticExpression? | IntervalExpression | S_DOUBLE | S_LONG | S_HEX | CastExpression | CharacterPrimary | K_TIME_KEY_EXPR | 'CURRENT' | DateTimeLiteralExpression | 'ARRAY' ArrayConstructor | NextValExpression | ConnectByRootOperator | 'ALL' | Column | S_CHAR_LITERAL | ( '{d' | '{t' | '{ts' ) S_CHAR_LITERAL '}' | ParenthesedSelect | ParenthesedExpressionList ( '.' RelObjectNameExt )? ) ( 'COLLATE' S_IDENTIFIER )? IntervalExpressionWithoutInterval? ArrayExpression? ( '::' ColDataType )* ( 'AT' K_DATETIMELITERAL 'ZONE' PrimaryExpression )* |
ConnectByRootOperator¶
::= 'CONNECT_BY_ROOT' Column |
Referenced by:
|
NextValExpression¶
Referenced by:
|
JdbcNamedParameter¶
::= ( ':' | '&' ) IdentifierChain |
Referenced by:
|
OracleNamedFunctionParameter¶
::= RelObjectNameExt2 '=>' Expression |
Referenced by:
|
UserVariable¶
::= ( '@' | '@@' ) IdentifierChain |
NumericBind¶
::= ':' S_LONG |
Referenced by:
|
DateTimeLiteralExpression¶
Referenced by:
|
RangeExpression¶
::= ':' Expression |
Referenced by:
|
ArrayConstructor¶
::= '[' ( ( Expression RangeExpression? | ArrayConstructor ) ( ',' ( Expression RangeExpression? | ArrayConstructor ) )* )? ']' |
Referenced by:
|
ParenthesedExpression¶
::= '(' PrimaryExpression ')' |
Referenced by:
|
JsonExpression¶
::= ( CaseWhenExpression | SimpleJdbcParameter | JdbcNamedParameter | UserVariable | JsonFunction | JsonAggregateFunction | FullTextSearch | Function | Column | S_CHAR_LITERAL | ParenthesedExpression | ParenthesedSelect ) ( '::' ColDataType )* ( ( '->' | '->>' ) ( S_CHAR_LITERAL | S_LONG ) | ( '#>' | '#>>' ) S_CHAR_LITERAL )+ ( ( '::' ColDataType )+ ( ( '->' | '->>' ) ( S_CHAR_LITERAL | S_LONG ) | ( '#>' | '#>>' ) S_CHAR_LITERAL )* )* |
Referenced by:
|
JsonFunction¶
::= ( 'JSON_OBJECT' '(' ( 'KEY'? S_CHAR_LITERAL ( ( ':' | ',' | 'VALUE' ) Expression ( 'FORMAT' 'JSON' )? )? ( ',' 'KEY'? S_CHAR_LITERAL ( ':' | ',' | 'VALUE' ) Expression ( 'FORMAT' 'JSON' )? )* )? ( ( 'NULL' | 'ABSENT' ) 'ON' 'NULL' )? ( ( 'WITH' | 'WITHOUT'
) 'UNIQUE' 'KEYS' )? | 'JSON_ARRAY' '(' ( 'NULL' 'ON' 'NULL' | Expression ( 'FORMAT' 'JSON' )? ( ',' Expression ( 'FORMAT' 'JSON' )? )* )* ( 'ABSENT' 'ON' 'NULL' )? ) ')' |
Referenced by:
|
JsonAggregateFunction¶
::= ( 'JSON_OBJECTAGG' '(' 'KEY'? ( DT_ZONE | S_DOUBLE | S_LONG | S_HEX | S_CHAR_LITERAL | S_IDENTIFIER | S_QUOTED_IDENTIFIER ) ( ':' | 'VALUE' ) ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) ( 'FORMAT' 'JSON' )? ( ( 'NULL' | 'ABSENT' ) 'ON' 'NULL' )? ( ( 'WITH' | 'WITHOUT'
) 'UNIQUE' 'KEYS' )? | 'JSON_ARRAYAGG' '(' Expression ( 'FORMAT' 'JSON' )? OrderByElements? ( ( 'NULL' | 'ABSENT' ) 'ON' 'NULL' )? ) ')' ( 'FILTER' '(' 'WHERE' Expression ')' )? ( 'OVER' '(' ( 'PARTITION' 'BY' ( ComplexExpressionList | '(' ComplexExpressionList ')' ) )? OrderByElements? WindowElement? ')' )? |
Referenced by:
|
IntervalExpression¶
::= 'INTERVAL' '-'? ( S_LONG | S_DOUBLE | S_CHAR_LITERAL | SimpleJdbcParameter | JdbcNamedParameter | Function | Column ) ( S_IDENTIFIER | K_DATE_LITERAL )? |
Referenced by:
|
IntervalExpressionWithoutInterval¶
::= K_DATE_LITERAL |
Referenced by:
|
KeepExpression¶
::= 'KEEP' '(' S_IDENTIFIER ( 'FIRST' | 'LAST' ) OrderByElements ')' |
Referenced by:
|
windowFun¶
::= ( ( 'IGNORE' 'NULLS' )? 'OVER' | 'WITHIN' 'GROUP' ) ( RelObjectName | windowDefinition ( 'OVER' '(' ( 'PARTITION' 'BY' ( ComplexExpressionList | '(' ComplexExpressionList ')' ) )? ')' )? ) |
Referenced by:
|
windowDefinition¶
::= '(' ( 'PARTITION' 'BY' ( ComplexExpressionList | '(' ComplexExpressionList ')' ) )? OrderByElements? WindowElement? ')' |
Referenced by:
|
AnalyticExpression¶
::= 'FILTER' '(' 'WHERE' Expression ')' windowFun?
|
Referenced by:
|
WindowElement¶
::= ( 'ROWS' | 'RANGE' ) ( 'BETWEEN' WindowOffset 'AND' )? WindowOffset |
Referenced by:
|
WindowOffset¶
::= ( 'UNBOUNDED' | SimpleExpression ) ( 'PRECEDING' | 'FOLLOWING' )
| 'CURRENT' 'ROW' |
Referenced by:
|
ExtractExpression¶
Referenced by:
|
CastExpression¶
::= ( 'CAST' | 'SAFE_CAST' | 'TRY_CAST' ) '(' SimpleExpression 'AS' ( 'ROW' '(' ColumnDefinition ( ',' ColumnDefinition )* ')' | ColDataType ) ')' |
Referenced by:
|
CaseWhenExpression¶
::= 'CASE' Expression? WhenThenSearchCondition+ ( 'ELSE' ( '(' CaseWhenExpression ')' | CaseWhenExpression | Expression | SimpleExpression ) )? 'END' |
Referenced by:
|
WhenThenSearchCondition¶
Referenced by:
|
RowConstructor¶
::= 'ROW' ParenthesedExpressionList |
Referenced by:
|
VariableExpression¶
::= UserVariable '=' SimpleExpression |
Not referenced by any.
|
Execute¶
Referenced by:
|
FullTextSearch¶
::= 'MATCH' '(' ColumnList ')' 'AGAINST' '(' ( S_CHAR_LITERAL | SimpleJdbcParameter | SimpleJdbcNamedParameter ) ( 'IN NATURAL LANGUAGE MODE' | 'IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION'
| 'IN BOOLEAN MODE' | 'WITH QUERY EXPANSION' )? ')' |
Referenced by:
|
Function¶
Function ::= '{' 'FN' InternalFunction '}'
|
SpecialStringFunctionWithNamedParameters¶
Referenced by:
|
InternalFunction¶
::= RelObjectNameList '(' ( ( 'DISTINCT' | 'ALL' | 'UNIQUE' )? ( '*' | AllTableColumns | ExpressionList OrderByElements? | Select ) )? ( 'IGNORE' 'NULLS' )? ')' ( '.' ( Function | Column ) )? KeepExpression? |
Referenced by:
|
XMLSerializeExpr¶
::= 'XMLSERIALIZE' '(' 'XMLAGG' '(' 'XMLTEXT' '(' SimpleExpression ')' OrderByElements? ')' 'AS' ColDataType ')' |
Referenced by:
|
MySQLGroupConcat¶
::= 'GROUP_CONCAT' '(' 'DISTINCT'? ExpressionList OrderByElements? ( 'SEPARATOR' S_CHAR_LITERAL )? ')' |
Referenced by:
|
TableFunction¶
Referenced by:
|
ColumnNamesWithParamsList¶
Referenced by:
|
Index¶
Referenced by:
|
CreateIndex¶
::= CreateParameter? 'INDEX' Index 'ON' Table ( 'USING' S_IDENTIFIER )? ColumnNamesWithParamsList CreateParameter* |
Referenced by:
|
ColumnDefinition¶
Referenced by:
|
CreateSchema¶
::= 'SCHEMA' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER )? ( 'AUTHORIZATION' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) )? PathSpecification? ( 'CREATE' CreateTable | CreateView )* |
Referenced by:
|
PathSpecification¶
Referenced by:
|
CreateTable¶
::= 'UNLOGGED'? 'GLOBAL'? CreateParameter* 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? Table ( '(' ( RelObjectName ( ',' RelObjectName )* | ColumnDefinition ( ',' ( ( 'INDEX' | 'UNIQUE'? 'FULLTEXT'? 'KEY' ) RelObjectName ColumnNamesWithParamsList CreateParameter* | ( 'CONSTRAINT' RelObjectName )? ( ( 'PRIMARY' 'KEY' | 'UNIQUE' 'KEY'? ) ColumnNamesWithParamsList CreateParameter* | 'FOREIGN' 'KEY' ColumnNamesWithParamsList 'REFERENCES' Table ColumnsNamesList ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? | 'CHECK' ( '(' Expression ')' )* ) | 'EXCLUDE' 'WHERE' ( '(' Expression ')' )* | ColumnDefinition ) )* ) ')' )? CreateParameter* RowMovement? ( 'AS' Select )? ( 'LIKE' ( '(' Table ')' | Table ) )? ( ',' SpannerInterleaveIn )? |
Referenced by:
|
SpannerInterleaveIn¶
::= 'INTERLEAVE' 'IN' 'PARENT' Table ( 'ON' 'DELETE' ( 'NO' 'ACTION' | 'CASCADE' ) )? |
Referenced by:
|
ColDataType¶
::= ( 'ARRAY' '<' ColDataType '>' | ( 'BYTES' | 'STRING' | 'JSON' ) '(' ( S_LONG | S_IDENTIFIER ) ')' | ( 'CHARACTER' | 'BIT' ) 'VARYING'? | 'DOUBLE' 'PRECISION'? | ( S_IDENTIFIER | S_QUOTED_IDENTIFIER | K_DATETIMELITERAL | K_DATE_LITERAL | 'XML' | 'INTERVAL' | DT_ZONE | 'CHAR' | 'SET' | 'BINARY' | 'JSON' | 'STRING' ) ( '.' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) )? | ( 'UNSIGNED' | 'SIGNED' ) S_IDENTIFIER? ) ( '(' ( ( S_LONG ( 'BYTE' | 'CHAR' )? | S_CHAR_LITERAL | S_IDENTIFIER | 'CHAR' ) ','? )* ')' )? ( '[' S_LONG? ']' )* ( 'CHARACTER' 'SET' ( S_IDENTIFIER | 'BINARY' ) )? |
Analyze¶
Referenced by:
|
CreateView¶
::= ( 'NO'? 'FORCE' )? ( 'TEMP' | 'TEMPORARY' )? 'MATERIALIZED'? 'VIEW' Table ( 'AUTO' 'REFRESH' ( 'YES' | 'NO' ) )? ( 'IF' 'NOT' 'EXISTS' )? ColumnsNamesList? 'AS' Select ( 'WITH' 'READ' 'ONLY' )? |
Referenced by:
|
Action¶
Action ::= 'CASCADE'
| 'RESTRICT'
| 'NO' 'ACTION'
| 'SET' ( 'NULL' | 'DEFAULT' ) |
Referenced by:
|
AlterView¶
Referenced by:
|
CreateParameter¶
| ( 'USING' 'INDEX' )? 'TABLESPACE' RelObjectName
| 'NULL'
| 'NOT'
| 'PRIMARY'
| 'FOREIGN'
| 'REFERENCES'
| 'KEY'
| 'STORED'
| 'ON'
| 'COMMIT'
| 'DROP'
| 'ROWS'
| 'UNIQUE'
| 'CASCADE'
| 'DELETE'
| 'UPDATE'
| 'CONSTRAINT'
| 'WITH'
| 'EXCLUDE'
| 'WHERE'
| 'UNSIGNED'
| 'TEMP'
| 'TEMPORARY'
| 'PARTITION'
| 'BY'
| 'IN'
| 'TYPE'
| 'COMMENT'
| 'USING'
| 'COLLATE'
| 'ASC'
| 'DESC'
| 'TRUE'
| 'FALSE'
| 'PARALLEL'
| 'BINARY'
| 'START'
| '='
| ( 'DEFAULT' | 'AS' | 'CHECK' ) ( '(' Expression ')' )?
| ( '+' | '-' )? S_LONG
| S_DOUBLE
| AList
| 'CHARACTER' 'SET'
| 'ARRAY' ArrayConstructor
| '::' ColDataType |
RowMovement¶
::= ( 'ENABLE' | 'DISABLE' ) 'ROW' 'MOVEMENT' |
Referenced by:
|
AList¶
AList ::= '(' ( ( S_LONG | S_DOUBLE | S_CHAR_LITERAL | RelObjectNameWithoutValue ) ( ',' | '=' )? )* ')' |
Referenced by:
|
ColumnsNamesListItem¶
::= RelObjectName ( '(' S_LONG ')' )? |
Referenced by:
|
ColumnsNamesList¶
::= '(' ColumnsNamesListItem ( ',' ColumnsNamesListItem )* ')' |
Referenced by:
|
FuncArgsListItem¶
Referenced by:
|
FuncArgsList¶
::= '(' ( FuncArgsListItem ( ',' FuncArgsListItem )* )? ')' |
Referenced by:
|
Drop¶
Drop ::= 'DROP' 'MATERIALIZED'? ( S_IDENTIFIER | 'TEMPORARY'? 'TABLE' | 'INDEX' | 'VIEW' | 'SCHEMA' | 'SEQUENCE' | 'FUNCTION' )
( 'IF' 'EXISTS' )? Table FuncArgsList? ( S_IDENTIFIER | 'CASCADE' | 'RESTRICT' | 'ON' )* |
Referenced by:
|
Truncate¶
Referenced by:
|
AlterExpressionColumnDataType¶
Referenced by:
|
AlterExpressionColumnDropNotNull¶
::= RelObjectName 'DROP' 'NOT'? 'NULL' |
Referenced by:
|
AlterExpressionColumnDropDefault¶
::= RelObjectName 'DROP' 'DEFAULT' |
Referenced by:
|
AlterExpressionConstraintState¶
::= ( 'NOT'? 'DEFERRABLE' | 'VALIDATE' | 'NOVALIDATE' | 'ENABLE' | 'DISABLE'
)* |
Referenced by:
|
AlterExpression¶
::= ( 'ADD' | 'ALTER' | 'MODIFY' ) ( ( ( 'PRIMARY' 'KEY' | ( 'KEY' | 'INDEX'
) RelObjectName ) ColumnsNamesList AlterExpressionConstraintState | 'UNIQUE' ( ( 'KEY' | 'INDEX' ) ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) )? ColumnsNamesList ) ( 'USING' RelObjectName )? | 'COLUMN'? ( '(' AlterExpressionColumnDataType ( ',' AlterExpressionColumnDataType )* ')' | AlterExpressionColumnDataType | AlterExpressionColumnDropNotNull | AlterExpressionColumnDropDefault ) | '(' AlterExpressionColumnDataType ( ',' AlterExpressionColumnDataType )* ')' | 'FOREIGN' 'KEY' ColumnsNamesList 'REFERENCES' Table ColumnsNamesList? ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? | 'CONSTRAINT' RelObjectName ( ( 'FOREIGN' 'KEY' ColumnsNamesList 'REFERENCES' Table ColumnsNamesList? ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? ( 'ON' ( 'DELETE' | 'UPDATE' ) Action )? | 'KEY' ColumnsNamesList ) AlterExpressionConstraintState | ( 'PRIMARY' 'KEY' | 'UNIQUE' ( 'KEY' | 'INDEX' )? ) ColumnsNamesList AlterExpressionConstraintState ( 'USING' RelObjectName )? | 'CHECK' ( '(' Expression ')' )* ) | RelObjectName 'COMMENT' S_CHAR_LITERAL )
| 'DROP' ( ( ColumnsNamesList | 'COLUMN'? ( 'IF' 'EXISTS' )? ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) ) 'INVALIDATE'? ( 'CASCADE' 'CONSTRAINTS'? )? | 'INDEX' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) | ( ( 'UNIQUE' | 'FOREIGN' 'KEY' ) ColumnsNamesList | 'PRIMARY' 'KEY' | 'CONSTRAINT' ( 'IF' 'EXISTS' )? ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) ) ( 'CASCADE' | 'RESTRICT' )? )
| 'ALGORITHM' '='? RelObjectName
| 'RENAME' ( 'COLUMN'? ( S_IDENTIFIER | S_QUOTED_IDENTIFIER ) )? 'TO' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER )
| 'COMMENT' S_CHAR_LITERAL
|
Referenced by:
|
Alter¶
Alter ::= 'ALTER' ( AlterTable | AlterSession | AlterView | AlterSystemStatement | AlterSequence | captureRest )
| 'REPLACE' ( AlterView | captureRest ) |
Referenced by:
|
AlterTable¶
Referenced by:
|
AlterSession¶
::= 'SESSION' ( 'ADVISE' ( 'COMMIT' | 'ROLLBACK' | 'NOTHING' ) | 'CLOSE'
'DATABASE' 'LINK' | ( 'ENABLE' | 'DISABLE' ) ( 'COMMIT' 'IN' 'PROCEDURE' | 'GUARD'
| 'PARALLEL' ( 'DML' | 'DDL' | 'QUERY' ) | 'RESUMABLE' ) | 'FORCE' 'PARALLEL' ( 'DML'
| 'DDL' | 'QUERY' ) | 'SET' ) ( S_CHAR_LITERAL | S_IDENTIFIER | '=' | S_LONG | 'PARALLEL' )* |
Referenced by:
|
AlterSystemStatement¶
::= 'SYSTEM' ( 'ARCHIVE' 'LOG' | 'CHECKPOINT' | 'DUMP' 'ACTIVE' 'SESSION'
'HISTORY' | ( 'ENABLE' | 'DISABLE' ) ( 'DISTRIBUTED RECOVERY' | 'RESTRICTED SESSION'
) | 'FLUSH' | 'DISCONNECT' 'SESSION' | 'KILL SESSION' | 'SWITCH' | 'SUSPEND' | 'RESUME'
| 'QUIESCE' 'RESTRICTED' | 'UNQUIESCE' | 'SHUTDOWN' | 'REGISTER' | 'SET' | 'RESET'
) captureRest |
Referenced by:
|
Wait¶
Referenced by:
|
SavepointStatement¶
::= 'SAVEPOINT' S_IDENTIFIER |
Referenced by:
|
RollbackStatement¶
::= 'ROLLBACK' 'WORK'? ( 'TO' 'SAVEPOINT'? S_IDENTIFIER | 'FORCE' S_CHAR_LITERAL )? |
Referenced by:
|
Comment¶
Referenced by:
|
Grant¶
Grant ::= 'GRANT' ( ( readGrantTypes ( ',' readGrantTypes )* )? 'ON' RelObjectNameList | S_IDENTIFIER ) 'TO' UsersList |
Referenced by:
|
UsersList¶
::= RelObjectName ( ',' ColumnsNamesListItem )* |
Referenced by:
|
readGrantTypes¶
::= K_SELECT
| 'INSERT'
| 'UPDATE'
| 'DELETE'
| 'EXECUTE'
| 'ALTER'
| 'DROP' |
Referenced by:
|
Sequence¶
Referenced by:
|
SequenceParameters¶
Referenced by:
|
CreateSequence¶
::= 'SEQUENCE' Sequence SequenceParameters |
Referenced by:
|
AlterSequence¶
::= 'SEQUENCE' Sequence SequenceParameters |
Referenced by:
|
Create¶
Create ::= 'CREATE' ( 'OR' 'REPLACE' )? ( CreateFunctionStatement | CreateSchema | CreateSequence | CreateSynonym | CreateTable | CreateView | ( 'TRIGGER' | 'DOMAIN' )? captureRest | CreateIndex ) |
Referenced by:
|
CreateFunctionStatement¶
::= ( 'FUNCTION' | 'PROCEDURE' ) captureFunctionBody |
Referenced by:
|
CreateSynonym¶
::= 'PUBLIC'? 'SYNONYM' Synonym 'FOR' RelObjectNameList |
Referenced by:
|
Synonym¶
Referenced by:
|
UnsupportedStatement¶
Referenced by:
|
IdentifierChain¶
::= RelObjectNameExt2 ( '.' RelObjectNameExt2 )* |
Referenced by:
|
CharacterPrimary¶
Referenced by:
|
TranscodingFunction¶
::= 'CONVERT' '(' Expression 'USING' IdentifierChain ')' |
Referenced by:
|
TrimFunction¶
::= 'TRIM' '(' ( 'LEADING' | 'TRAILING' | 'BOTH' )? Expression? ( ( ',' | 'FROM' ) Expression )? ')' |
Referenced by:
|
WHITESPACE¶
::= [ #x9#xD#xA] |
K_DATETIMELITERAL¶
::= 'DATE'
| 'TIME'
| 'TIMESTAMP'
| 'TIMESTAMPTZ' |
K_DATE_LITERAL¶
::= 'YEAR'
| 'MONTH'
| 'DAY'
| 'HOUR'
| 'MINUTE'
| 'SECOND' |
K_ISOLATION¶
::= 'UR'
| 'RS'
| 'RR'
| 'CS' |
Referenced by:
|
K_NEXTVAL¶
::= 'NEXTVAL' ( ' '+ 'FOR' )?
| 'NEXT' ' '+ 'VALUE' ' '+ 'FOR' |
Referenced by:
|
K_SELECT¶
K_SELECT ::= 'SELECT'
| 'SEL' |
Referenced by:
|
K_TIME_KEY_EXPR¶
::= 'CURRENT' ( '_' | ' '+ ) ( 'TIMESTAMP' | 'TIME' | 'DATE' ) '()'? |
Referenced by:
|
K_STRING_FUNCTION_NAME¶
::= 'SUBSTR'
| 'SUBSTRING'
| 'TRIM'
| 'POSITION'
| 'OVERLAY' |
ST_SEMICOLON¶
::= ';'
| #xA ( [/#xA] #xA | 'go' ) |
Referenced by:
|
OP_GREATERTHANEQUALS¶
::= '>' WHITESPACE* '=' |
Referenced by:
|
OP_MINORTHANEQUALS¶
::= '<' WHITESPACE* '=' |
Referenced by:
|
OP_NOTEQUALSSTANDARD¶
::= '<' WHITESPACE* '>' |
Referenced by:
|
OP_NOTEQUALSBANG¶
::= '!' WHITESPACE* '=' |
Referenced by:
|
OP_CONCAT¶
::= '|' WHITESPACE* '|' |
Referenced by:
|
DT_ZONE¶
DT_ZONE ::= K_DATETIMELITERAL WHITESPACE* ( '(' S_LONG ')' )? WHITESPACE* ( 'WITH' | 'WITHOUT' ) WHITESPACE+ ( 'LOCAL' WHITESPACE+ )? 'TIME' WHITESPACE+ 'ZONE' |
Referenced by:
|
S_DOUBLE¶
S_LONG¶
Referenced by:
|
DIGIT¶
DIGIT ::= [0-9] |
Referenced by:
|
S_HEX¶
| '0x' HEX_VALUE+ |
Referenced by:
|
HEX_VALUE¶
::= [0-9A-F] |
Referenced by:
|
LINE_COMMENT¶
::= ( '--' | '//' ) [^#xD#xA]* |
Not referenced by any.
|
MULTI_LINE_COMMENT¶
::= '/*' [^*]* '*' ( ( [^*/] [^*]* )? '*' )* '/' |
Not referenced by any.
|
S_IDENTIFIER¶
::= LETTER PART_LETTER* |
LETTER¶
| Nd
| [$_#x23] |
Referenced by:
|
PART_LETTER¶
| [$_@#x23] |
Referenced by:
|
UnicodeIdentifierStart¶
::= #xB7
| Ll
| Lm
| Lo
| Lt
| Lu
| Nl
| CJK |
Referenced by:
|