## caseExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
caseExpression_start([caseExpression])
caseExpression_start --> caseExpression_0_0[case]
caseExpression_0_0 --> caseExpression_0_1[caseWhenThenExpression]
caseExpression_0_1 --> caseExpression_0_2[caseElseExpression]
caseExpression_0_2 --> caseExpression_0_3[end]
caseExpression_0_3 --> caseExpression_end(( ))
```
## caseWhenThenExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
caseWhenThenExpression_start([caseWhenThenExpression])
caseWhenThenExpression_start --> caseWhenThenExpression_0_0[when]
caseWhenThenExpression_0_0 --> caseWhenThenExpression_0_1[expression]
caseWhenThenExpression_0_1 --> caseWhenThenExpression_0_2[then]
caseWhenThenExpression_0_2 --> caseWhenThenExpression_0_3[expression]
caseWhenThenExpression_0_3 --> caseWhenThenExpression_end(( ))
```
## caseElseExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
caseElseExpression_start([caseElseExpression])
caseElseExpression_start --> caseElseExpression_0_0[else]
caseElseExpression_0_0 --> caseElseExpression_0_1[expression]
caseElseExpression_0_1 --> caseElseExpression_end(( ))
```
## castExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
castExpression_start([castExpression])
castExpression_start --> castExpression_0_0[CAST]
castExpression_0_0 --> castExpression_0_1[parenthesisOpen]
castExpression_0_1 --> castExpression_0_2[expression]
castExpression_0_2 --> castExpression_0_3[AS]
castExpression_0_3 --> castExpression_0_4[sqlDataTypeExtended]
castExpression_0_4 --> castExpression_0_5[parenthesisClose]
castExpression_0_5 --> castExpression_end(( ))
```
## case
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> case
case -->| | CASE
CASE --> End(( ))
```
## when
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> when
when -->| | WHEN
WHEN --> End(( ))
```
## then
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> then
then -->| | THEN
THEN --> End(( ))
```
## else
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> else
else -->| | ELSE
ELSE --> End(( ))
```
## end
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> end2
end2 -->| | END
END --> End(( ))
```
## not
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> not
not -->| | NOT
NOT --> End(( ))
```
## is
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> is
is -->| | IS
IS --> End(( ))
```
## are
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> are
are -->| | ARE
ARE --> End(( ))
```
## and
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> and
and -->| | AND
AND --> End(( ))
```
## or
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> or
or -->| | OR
OR --> End(( ))
```
## true
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> true
true -->| | TRUE
TRUE --> End(( ))
```
## false
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> false
false -->| | FALSE
FALSE --> End(( ))
```
## parameterExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
parameterExpression_start([parameterExpression])
parameterExpression_start --> parameterExpression_0_0[COLON]
parameterExpression_0_0 --> parameterExpression_0_1[identifier]
parameterExpression_0_1 --> parameterExpression_end(( ))
```
## gt
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> gt
gt -->| | GT
GT --> End(( ))
```
## ge
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> ge
ge -->| | GE
GE --> End(( ))
```
## lt
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> lt
lt -->| | LT
LT --> End(( ))
```
## le
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> le
le -->| | LE
LE --> End(( ))
```
## eq
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> eq
eq -->| | EQ
EQ --> End(( ))
```
## neq
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> neq
neq -->| | NEQ
NEQ --> End(( ))
```
## like
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> like
like -->| | LIKE
LIKE --> End(( ))
```
## between
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> between
between -->| | BETWEEN
BETWEEN --> End(( ))
```
## in_
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> in_
in_ -->| | IN
IN --> End(( ))
```
## expression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
expression_start([expression])
expression_start --> expression_0_0[minus]
expression_0_0 --> expression_0_1[plus]
expression_0_1 --> expression_0_2[not]
expression_0_2 --> expression_0_3[expression]
expression_0_3 --> expression_end(( ))
expression_start --> expression_1_0[expression]
expression_1_0 --> expression_1_1[concat]
expression_1_1 --> expression_1_2[times]
expression_1_2 --> expression_1_3[divide]
expression_1_3 --> expression_1_4[plus]
expression_1_4 --> expression_1_5[minus]
expression_1_5 --> expression_1_6[gt]
expression_1_6 --> expression_1_7[ge]
expression_1_7 --> expression_1_8[lt]
expression_1_8 --> expression_1_9[le]
expression_1_9 --> expression_1_10[eq]
expression_1_10 --> expression_1_11[neq]
expression_1_11 --> expression_1_12[and]
expression_1_12 --> expression_1_13[or]
expression_1_13 --> expression_1_14[expression]
expression_1_14 --> expression_1_15[not]
expression_1_15 --> expression_1_16[like]
expression_1_16 --> expression_1_17[between]
expression_1_17 --> expression_1_18[expression]
expression_1_18 --> expression_1_19[and]
expression_1_19 --> expression_1_20[expression]
expression_1_20 --> expression_1_21[in_]
expression_1_21 --> expression_1_22[parenthesisOpen]
expression_1_22 --> expression_1_23[expression]
expression_1_23 --> expression_1_24[COMMA]
expression_1_24 --> expression_1_25[expression]
expression_1_25 --> expression_1_26[selectStatement]
expression_1_26 --> expression_1_27[parenthesisClose]
expression_1_27 --> expression_1_28[is]
expression_1_28 --> expression_1_29[not]
expression_1_29 --> expression_1_30[NULL]
expression_1_30 --> expression_end(( ))
expression_start --> expression_2_0[not]
expression_2_0 --> expression_2_1[exists]
expression_2_1 --> expression_2_2[parenthesisOpen]
expression_2_2 --> expression_2_3[selectStatement]
expression_2_3 --> expression_2_4[parenthesisOpen]
expression_2_4 --> expression_2_5[selectStatement]
expression_2_5 --> expression_2_6[expression]
expression_2_6 --> expression_2_7[parenthesisClose]
expression_2_7 --> expression_end(( ))
expression_start --> expression_3_0[constantExpression]
expression_3_0 --> expression_end(( ))
expression_start --> expression_4_0[functionExpression]
expression_4_0 --> expression_end(( ))
expression_start --> expression_5_0[parameterExpression]
expression_5_0 --> expression_end(( ))
expression_start --> expression_6_0[triggerRecordVariableExpression]
expression_6_0 --> expression_end(( ))
expression_start --> expression_7_0[castExpression]
expression_7_0 --> expression_end(( ))
expression_start --> expression_8_0[caseExpression]
expression_8_0 --> expression_end(( ))
expression_start --> expression_9_0[arrayExpression]
expression_9_0 --> expression_end(( ))
expression_start --> expression_10_0[pSqlCallProcedureStatementNS]
expression_10_0 --> expression_end(( ))
expression_start --> expression_11_0[fieldIdentifier]
expression_11_0 --> expression_end(( ))
expression_start --> expression_12_0[bindVariable]
expression_12_0 --> expression_end(( ))
```
## bindVariable
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> bindVariable
bindVariable -->| | BIND_VARIABLE
BIND_VARIABLE --> End(( ))
```
## arrayExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
arrayExpression_start([arrayExpression])
arrayExpression_start --> arrayExpression_0_0[ARRAY_OPEN]
arrayExpression_0_0 --> arrayExpression_0_1[expression]
arrayExpression_0_1 --> arrayExpression_0_2[COMMA]
arrayExpression_0_2 --> arrayExpression_0_3[expression]
arrayExpression_0_3 --> arrayExpression_0_4[ARRAY_CLOSE]
arrayExpression_0_4 --> arrayExpression_end(( ))
```
## functionExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
functionExpression_start([functionExpression])
functionExpression_start --> functionExpression_0_0[abs]
functionExpression_0_0 --> functionExpression_0_1[acos]
functionExpression_0_1 --> functionExpression_0_2[anonymize]
functionExpression_0_2 --> functionExpression_0_3[ascii]
functionExpression_0_3 --> functionExpression_0_4[ascii_to_blob]
functionExpression_0_4 --> functionExpression_0_5[asin]
functionExpression_0_5 --> functionExpression_0_6[atan]
functionExpression_0_6 --> functionExpression_0_7[atan2]
functionExpression_0_7 --> functionExpression_0_8[base64_decode]
functionExpression_0_8 --> functionExpression_0_9[base64_encode]
functionExpression_0_9 --> functionExpression_0_10[basename]
functionExpression_0_10 --> functionExpression_0_11[bit_length]
functionExpression_0_11 --> functionExpression_0_12[octet_length]
functionExpression_0_12 --> functionExpression_0_13[camel]
functionExpression_0_13 --> functionExpression_0_14[ceil]
functionExpression_0_14 --> functionExpression_0_15[chr]
functionExpression_0_15 --> functionExpression_0_16[charindex]
functionExpression_0_16 --> functionExpression_0_17[coalesce]
functionExpression_0_17 --> functionExpression_0_18[concat_func]
functionExpression_0_18 --> functionExpression_0_19[cos]
functionExpression_0_19 --> functionExpression_0_20[covfefify]
functionExpression_0_20 --> functionExpression_0_21[compress]
functionExpression_0_21 --> functionExpression_0_22[convertnumerictotime]
functionExpression_0_22 --> functionExpression_0_23[csvdecode]
functionExpression_0_23 --> functionExpression_0_24[csvencode]
functionExpression_0_24 --> functionExpression_0_25[uncompress]
functionExpression_0_25 --> functionExpression_0_26[dateadd]
functionExpression_0_26 --> functionExpression_0_27[datepart]
functionExpression_0_27 --> functionExpression_0_28[date_ceil]
functionExpression_0_28 --> functionExpression_0_29[date_floor]
functionExpression_0_29 --> functionExpression_0_30[date_round]
functionExpression_0_30 --> functionExpression_0_31[date_trunc]
functionExpression_0_31 --> functionExpression_0_32[day]
functionExpression_0_32 --> functionExpression_0_33[dayofweek]
functionExpression_0_33 --> functionExpression_0_34[dayofyear]
functionExpression_0_34 --> functionExpression_0_35[dense_rank]
functionExpression_0_35 --> functionExpression_0_36[decode]
functionExpression_0_36 --> functionExpression_0_37[double_metaphone]
functionExpression_0_37 --> functionExpression_0_38[double_metaphone_alt]
functionExpression_0_38 --> functionExpression_0_39[excel_day]
functionExpression_0_39 --> functionExpression_0_40[exp_func]
functionExpression_0_40 --> functionExpression_0_41[floor]
functionExpression_0_41 --> functionExpression_0_42[from_unixtime]
functionExpression_0_42 --> functionExpression_0_43[gzip]
functionExpression_0_43 --> functionExpression_0_44[hour]
functionExpression_0_44 --> functionExpression_0_45[httpget]
functionExpression_0_45 --> functionExpression_0_46[httpget_text]
functionExpression_0_46 --> functionExpression_0_47[httppost]
functionExpression_0_47 --> functionExpression_0_48[initcap]
functionExpression_0_48 --> functionExpression_0_49[instr]
functionExpression_0_49 --> functionExpression_0_50[is_boolean]
functionExpression_0_50 --> functionExpression_0_51[is_date]
functionExpression_0_51 --> functionExpression_0_52[is_email]
functionExpression_0_52 --> functionExpression_0_53[is_guid]
functionExpression_0_53 --> functionExpression_0_54[is_iban]
functionExpression_0_54 --> functionExpression_0_55[is_number]
functionExpression_0_55 --> functionExpression_0_56[is_uri]
functionExpression_0_56 --> functionExpression_0_57[jsondecode]
functionExpression_0_57 --> functionExpression_0_58[jsonelement]
functionExpression_0_58 --> functionExpression_0_59[jsonencode]
functionExpression_0_59 --> functionExpression_0_60[left]
functionExpression_0_60 --> functionExpression_0_61[length]
functionExpression_0_61 --> functionExpression_0_62[levenshtein]
functionExpression_0_62 --> functionExpression_0_63[ln]
functionExpression_0_63 --> functionExpression_0_64[log]
functionExpression_0_64 --> functionExpression_0_65[lower]
functionExpression_0_65 --> functionExpression_0_66[lpad]
functionExpression_0_66 --> functionExpression_0_67[ltrim]
functionExpression_0_67 --> functionExpression_0_68[ltrimtext]
functionExpression_0_68 --> functionExpression_0_69[md5]
functionExpression_0_69 --> functionExpression_0_70[metaphone]
functionExpression_0_70 --> functionExpression_0_71[metaphone3]
functionExpression_0_71 --> functionExpression_0_72[metaphone3_alt]
functionExpression_0_72 --> functionExpression_0_73[microsecond]
functionExpression_0_73 --> functionExpression_0_74[millisecond]
functionExpression_0_74 --> functionExpression_0_75[minute]
functionExpression_0_75 --> functionExpression_0_76[mod]
functionExpression_0_76 --> functionExpression_0_77[month]
functionExpression_0_77 --> functionExpression_0_78[new_time]
functionExpression_0_78 --> functionExpression_0_79[newid]
functionExpression_0_79 --> functionExpression_0_80[number_to_speech]
functionExpression_0_80 --> functionExpression_0_81[normalize]
functionExpression_0_81 --> functionExpression_0_82[nvl]
functionExpression_0_82 --> functionExpression_0_83[object_exists]
functionExpression_0_83 --> functionExpression_0_84[power]
functionExpression_0_84 --> functionExpression_0_85[quarter]
functionExpression_0_85 --> functionExpression_0_86[quote_ident]
functionExpression_0_86 --> functionExpression_0_87[quote_literal]
functionExpression_0_87 --> functionExpression_0_88[quote_nullable]
functionExpression_0_88 --> functionExpression_0_89[raise_error]
functionExpression_0_89 --> functionExpression_0_90[random]
functionExpression_0_90 --> functionExpression_0_91[random_blob]
functionExpression_0_91 --> functionExpression_0_92[rand]
functionExpression_0_92 --> functionExpression_0_93[rank]
functionExpression_0_93 --> functionExpression_0_94[regexp_instr]
functionExpression_0_94 --> functionExpression_0_95[regexp_replace]
functionExpression_0_95 --> functionExpression_0_96[regexp_substr]
functionExpression_0_96 --> functionExpression_0_97[remainder]
functionExpression_0_97 --> functionExpression_0_98[replace]
functionExpression_0_98 --> functionExpression_0_99[repeat]
functionExpression_0_99 --> functionExpression_0_100[reverse]
functionExpression_0_100 --> functionExpression_0_101[right]
functionExpression_0_101 --> functionExpression_0_102[round]
functionExpression_0_102 --> functionExpression_0_103[row_number]
functionExpression_0_103 --> functionExpression_0_104[rpad]
functionExpression_0_104 --> functionExpression_0_105[rtrim]
functionExpression_0_105 --> functionExpression_0_106[rtrimtext]
functionExpression_0_106 --> functionExpression_0_107[second]
functionExpression_0_107 --> functionExpression_0_108[sign]
functionExpression_0_108 --> functionExpression_0_109[sin]
functionExpression_0_109 --> functionExpression_0_110[soundex]
functionExpression_0_110 --> functionExpression_0_111[split_part]
functionExpression_0_111 --> functionExpression_0_112[sql_variant]
functionExpression_0_112 --> functionExpression_0_113[sqrt]
functionExpression_0_113 --> functionExpression_0_114[substr]
functionExpression_0_114 --> functionExpression_0_115[sys_context]
functionExpression_0_115 --> functionExpression_0_116[tan]
functionExpression_0_116 --> functionExpression_0_117[to_array]
functionExpression_0_117 --> functionExpression_0_118[to_binary]
functionExpression_0_118 --> functionExpression_0_119[to_boolean]
functionExpression_0_119 --> functionExpression_0_120[to_char]
functionExpression_0_120 --> functionExpression_0_121[to_date]
functionExpression_0_121 --> functionExpression_0_122[to_number]
functionExpression_0_122 --> functionExpression_0_123[to_guid]
functionExpression_0_123 --> functionExpression_0_124[to_hex]
functionExpression_0_124 --> functionExpression_0_125[translate]
functionExpression_0_125 --> functionExpression_0_126[translate_resources]
functionExpression_0_126 --> functionExpression_0_127[trim]
functionExpression_0_127 --> functionExpression_0_128[trunc]
functionExpression_0_128 --> functionExpression_0_129[unicode_to_blob]
functionExpression_0_129 --> functionExpression_0_130[unistr]
functionExpression_0_130 --> functionExpression_0_131[unix_timestamp]
functionExpression_0_131 --> functionExpression_0_132[upper]
functionExpression_0_132 --> functionExpression_0_133[urldecode]
functionExpression_0_133 --> functionExpression_0_134[urlencode]
functionExpression_0_134 --> functionExpression_0_135[htmldecode]
functionExpression_0_135 --> functionExpression_0_136[htmlencode]
functionExpression_0_136 --> functionExpression_0_137[user]
functionExpression_0_137 --> functionExpression_0_138[ungzip]
functionExpression_0_138 --> functionExpression_0_139[xmlcomment]
functionExpression_0_139 --> functionExpression_0_140[xmldecode]
functionExpression_0_140 --> functionExpression_0_141[xmlencode]
functionExpression_0_141 --> functionExpression_0_142[xmlelement]
functionExpression_0_142 --> functionExpression_0_143[xmlformat]
functionExpression_0_143 --> functionExpression_0_144[xmltransform]
functionExpression_0_144 --> functionExpression_0_145[year]
functionExpression_0_145 --> functionExpression_0_146[add_months]
functionExpression_0_146 --> functionExpression_0_147[months_between]
functionExpression_0_147 --> functionExpression_0_148[zero_blob]
functionExpression_0_148 --> functionExpression_0_149[zlib_compress]
functionExpression_0_149 --> functionExpression_0_150[zlib_decompress]
functionExpression_0_150 --> functionExpression_0_151[IDENTIFIER]
functionExpression_0_151 --> functionExpression_0_152[parenthesisOpen]
functionExpression_0_152 --> functionExpression_0_153[expressionList]
functionExpression_0_153 --> functionExpression_0_154[parenthesisClose]
functionExpression_0_154 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_1_0[random]
functionExpression_1_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_2_0[rand]
functionExpression_2_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_3_0[row_number]
functionExpression_3_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_4_0[now]
functionExpression_4_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_5_0[utc]
functionExpression_5_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_6_0[utcoffset]
functionExpression_6_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_7_0[user]
functionExpression_7_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_8_0[sqlrowcount]
functionExpression_8_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_9_0[sqlerrm]
functionExpression_9_0 --> functionExpression_end(( ))
functionExpression_start --> functionExpression_10_0[sqlcode]
functionExpression_10_0 --> functionExpression_end(( ))
```
## divide
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> divide
divide -->| | DIVIDE
DIVIDE --> End(( ))
```
## exists
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> exists
exists -->| | EXISTS
EXISTS --> End(( ))
```
## ln
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> ln
ln -->| | LN
LN --> End(( ))
```
## minus
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> minus
minus -->| | MINUS
MINUS --> End(( ))
```
## plus
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> plus
plus -->| | PLUS
PLUS --> End(( ))
```
## times
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> times
times -->| | ASTERIX
ASTERIX --> End(( ))
```
## constantExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> constantExpression
constantExpression -->| | stringConstant
stringConstant --> End(( ))
constantExpression -->| | numericConstant
numericConstant --> End(( ))
constantExpression -->| | booleanConstant
booleanConstant --> End(( ))
constantExpression -->| | intervalConstant
intervalConstant --> End(( ))
constantExpression -->| | null
null --> End(( ))
```
## stringConstant
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
stringConstant_start([stringConstant])
stringConstant_start --> stringConstant_0_0[stringOrChar]
stringConstant_0_0 --> stringConstant_0_1[CONCAT_OP]
stringConstant_0_1 --> stringConstant_0_2[stringOrChar]
stringConstant_0_2 --> stringConstant_end(( ))
```
## stringOrChar
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> STRING_C
STRING_C --> parenthesisOpen
parenthesisOpen --> INT_OR_DECIMAL_C
INT_OR_DECIMAL_C --> parenthesisClose
parenthesisClose --> STRING_C
STRING_C --> End(( ))
```
## intervalConstant
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
intervalConstant_start([intervalConstant])
intervalConstant_start --> intervalConstant_0_0[INTERVAL]
intervalConstant_0_0 --> intervalConstant_0_1[stringConstant]
intervalConstant_0_1 --> intervalConstant_end(( ))
```
## numericConstant
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> numericConstant
numericConstant -->| | INT_OR_DECIMAL_C
INT_OR_DECIMAL_C --> End(( ))
numericConstant -->| | E_NOTATION_C
E_NOTATION_C --> End(( ))
```
## booleanConstant
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> booleanConstant
booleanConstant -->| | true
true --> End(( ))
booleanConstant -->| | false
false --> End(( ))
```