?? sql2.v
字號:
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
AMMSC shift 61
PARAMETER shift 62
USER shift 63
literal goto 64
column_ref goto 65
atom goto 66
scalar_exp goto 156
parameter_ref goto 69
function_ref goto 71
parameter goto 72
state 102
parameter_ref : parameter INDICATOR . parameter
PARAMETER shift 62
parameter goto 157
state 103
parameter_ref : parameter parameter . (183)
. reduce 183
state 104
table : NAME '.' NAME . (193)
. reduce 193
state 105
column : NAME . (211)
. reduce 211
state 106
assignment : column . '=' scalar_exp
assignment : column . '=' NULLX
'=' shift 158
state 107
update_statement_positioned : UPDATE table SET assignment_commalist . WHERE CURRENT OF cursor
assignment_commalist : assignment_commalist . ',' assignment
update_statement_searched : UPDATE table SET assignment_commalist . opt_where_clause
opt_where_clause : . (109)
',' shift 159
WHERE shift 160
. reduce 109
opt_where_clause goto 161
where_clause goto 85
state 108
assignment_commalist : assignment . (101)
. reduce 101
state 109
sql : WHENEVER NOT FOUND when_action . (216)
. reduce 216
state 110
when_action : GOTO NAME . (218)
. reduce 218
state 111
base_table_def : CREATE . TABLE table '(' base_table_element_commalist ')'
view_def : CREATE . VIEW table opt_column_commalist AS query_spec opt_with_check_option
TABLE shift 162
VIEW shift 163
state 112
privilege_def : GRANT . privileges ON table TO grantee_commalist opt_with_grant_option
ALL shift 164
DELETE shift 165
INSERT shift 166
REFERENCES shift 167
SELECT shift 168
UPDATE shift 169
privileges goto 170
operation_commalist goto 171
operation goto 172
state 113
schema : CREATE SCHEMA AUTHORIZATION user opt_schema_element_list . (4)
. reduce 4
state 114
opt_schema_element_list : schema_element_list . (6)
schema_element_list : schema_element_list . schema_element
CREATE shift 111
GRANT shift 112
. reduce 6
schema_element goto 173
base_table_def goto 116
view_def goto 117
privilege_def goto 118
state 115
schema_element_list : schema_element . (7)
. reduce 7
state 116
schema_element : base_table_def . (9)
. reduce 9
state 117
schema_element : view_def . (10)
. reduce 10
state 118
schema_element : privilege_def . (11)
. reduce 11
state 119
query_term : '(' . query_exp ')'
'(' shift 119
SELECT shift 120
query_spec goto 121
query_exp goto 174
query_term goto 123
state 120
query_spec : SELECT . opt_all_distinct selection table_exp
opt_all_distinct : . (96)
ALL shift 39
DISTINCT shift 40
. reduce 96
opt_all_distinct goto 175
state 121
query_term : query_spec . (114)
. reduce 114
state 122
cursor_def : DECLARE cursor CURSOR FOR query_exp . opt_order_by_clause
query_exp : query_exp . UNION query_term
query_exp : query_exp . UNION ALL query_term
opt_order_by_clause : . (60)
ORDER shift 176
UNION shift 177
. reduce 60
opt_order_by_clause goto 178
state 123
query_exp : query_term . (111)
. reduce 111
state 124
search_condition : '(' . search_condition ')'
scalar_exp : '(' . scalar_exp ')'
search_condition : . (132)
'(' shift 124
'+' shift 55
'-' shift 56
NAME shift 57
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
NOT shift 125
AMMSC shift 61
EXISTS shift 127
PARAMETER shift 62
USER shift 63
. reduce 132
literal goto 64
search_condition goto 179
column_ref goto 129
atom goto 66
scalar_exp goto 180
parameter_ref goto 69
predicate goto 131
comparison_predicate goto 132
between_predicate goto 133
like_predicate goto 134
test_for_null goto 135
in_predicate goto 136
all_or_any_predicate goto 137
existence_test goto 138
function_ref goto 71
parameter goto 72
state 125
search_condition : NOT . search_condition
search_condition : . (132)
'(' shift 124
'+' shift 55
'-' shift 56
NAME shift 57
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
NOT shift 125
AMMSC shift 61
EXISTS shift 127
PARAMETER shift 62
USER shift 63
. reduce 132
literal goto 64
search_condition goto 181
column_ref goto 129
atom goto 66
scalar_exp goto 130
parameter_ref goto 69
predicate goto 131
comparison_predicate goto 132
between_predicate goto 133
like_predicate goto 134
test_for_null goto 135
in_predicate goto 136
all_or_any_predicate goto 137
existence_test goto 138
function_ref goto 71
parameter goto 72
state 126
delete_statement_positioned : DELETE FROM table WHERE CURRENT . OF cursor
OF shift 182
state 127
existence_test : EXISTS . subquery
'(' shift 183
subquery goto 184
state 128
where_clause : WHERE search_condition . (125)
search_condition : search_condition . OR search_condition
search_condition : search_condition . AND search_condition
OR shift 185
AND shift 186
. reduce 125
state 129
test_for_null : column_ref . IS NOT NULLX
test_for_null : column_ref . IS NULLX
scalar_exp : column_ref . (174)
IS shift 187
. reduce 174
state 130
comparison_predicate : scalar_exp . COMPARISON scalar_exp
comparison_predicate : scalar_exp . COMPARISON subquery
between_predicate : scalar_exp . NOT BETWEEN scalar_exp AND scalar_exp
between_predicate : scalar_exp . BETWEEN scalar_exp AND scalar_exp
like_predicate : scalar_exp . NOT LIKE atom opt_escape
like_predicate : scalar_exp . LIKE atom opt_escape
in_predicate : scalar_exp . NOT IN '(' subquery ')'
in_predicate : scalar_exp . IN '(' subquery ')'
in_predicate : scalar_exp . NOT IN '(' atom_commalist ')'
in_predicate : scalar_exp . IN '(' atom_commalist ')'
all_or_any_predicate : scalar_exp . COMPARISON any_all_some subquery
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
'*' shift 97
'+' shift 98
'-' shift 99
'/' shift 100
NOT shift 188
COMPARISON shift 189
BETWEEN shift 190
IN shift 191
LIKE shift 192
state 131
search_condition : predicate . (137)
. reduce 137
state 132
predicate : comparison_predicate . (138)
. reduce 138
state 133
predicate : between_predicate . (139)
. reduce 139
state 134
predicate : like_predicate . (140)
. reduce 140
state 135
predicate : test_for_null . (141)
. reduce 141
state 136
predicate : in_predicate . (142)
. reduce 142
state 137
predicate : all_or_any_predicate . (143)
. reduce 143
state 138
predicate : existence_test . (144)
. reduce 144
state 139
target_commalist : target_commalist ',' . target
PARAMETER shift 62
target goto 193
parameter_ref goto 88
parameter goto 72
state 140
column_commalist : column . (34)
. reduce 34
state 141
column_commalist : column_commalist . ',' column
opt_column_commalist : '(' column_commalist . ')'
')' shift 194
',' shift 195
state 142
values_or_query_spec : VALUES . '(' insert_atom_commalist ')'
'(' shift 196
state 143
values_or_query_spec : query_spec . (88)
. reduce 88
state 144
insert_statement : INSERT INTO table opt_column_commalist values_or_query_spec . (86)
. reduce 86
state 145
scalar_exp : '(' scalar_exp ')' . (176)
. reduce 176
state 146
column_ref : NAME '.' NAME . (195)
column_ref : NAME '.' NAME . '.' NAME
'.' shift 197
. reduce 195
state 147
function_ref : AMMSC '(' '*' . ')'
')' shift 198
state 148
function_ref : AMMSC '(' ALL . scalar_exp ')'
'(' shift 53
'+' shift 55
'-' shift 56
NAME shift 57
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
AMMSC shift 61
PARAMETER shift 62
USER shift 63
literal goto 64
column_ref goto 65
atom goto 66
scalar_exp goto 199
parameter_ref goto 69
function_ref goto 71
parameter goto 72
state 149
function_ref : AMMSC '(' DISTINCT . column_ref ')'
NAME shift 57
column_ref goto 200
state 150
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
function_ref : AMMSC '(' scalar_exp . ')'
')' shift 201
'*' shift 97
'+' shift 98
'-' shift 99
'/' shift 100
state 151
select_statement : SELECT opt_all_distinct selection INTO target_commalist . table_exp
target_commalist : target_commalist . ',' target
',' shift 139
FROM shift 202
table_exp goto 203
from_clause goto 204
state 152
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp '*' scalar_exp . (169)
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
. reduce 169
state 153
scalar_exp : scalar_exp '+' scalar_exp . (167)
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
'*' shift 97
'/' shift 100
. reduce 167
state 154
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp '-' scalar_exp . (168)
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
'*' shift 97
'/' shift 100
. reduce 168
state 155
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp '/' scalar_exp . (170)
scalar_exp : scalar_exp . '/' scalar_exp
. reduce 170
state 156
scalar_exp : scalar_exp . '+' scalar_exp
scalar_exp : scalar_exp . '-' scalar_exp
scalar_exp : scalar_exp . '*' scalar_exp
scalar_exp : scalar_exp . '/' scalar_exp
scalar_exp_commalist : scalar_exp_commalist ',' scalar_exp . (178)
'*' shift 97
'+' shift 98
'-' shift 99
'/' shift 100
. reduce 178
state 157
parameter_ref : parameter INDICATOR parameter . (184)
. reduce 184
state 158
assignment : column '=' . scalar_exp
assignment : column '=' . NULLX
'(' shift 53
'+' shift 55
'-' shift 56
NAME shift 57
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
AMMSC shift 61
NULLX shift 205
PARAMETER shift 62
USER shift 63
literal goto 64
column_ref goto 65
atom goto 66
scalar_exp goto 206
parameter_ref goto 69
function_ref goto 71
parameter goto 72
state 159
assignment_commalist : assignment_commalist ',' . assignment
NAME shift 105
column goto 106
assignment goto 207
state 160
update_statement_positioned : UPDATE table SET assignment_commalist WHERE . CURRENT OF cursor
where_clause : WHERE . search_condition
search_condition : . (132)
'(' shift 124
'+' shift 55
'-' shift 56
NAME shift 57
STRING shift 58
INTNUM shift 59
APPROXNUM shift 60
NOT shift 125
AMMSC shift 61
CURRENT shift 208
EXISTS shift 127
PARAMETER shift 62
USER shift 63
. reduce 132
literal goto 64
search_condition goto 128
column_ref goto 129
atom goto 66
scalar_exp goto 130
parameter_ref goto 69
predicate goto 131
comparison_predicate goto 132
between_predicate goto 133
like_predicate goto 134
test_for_null goto 135
in_predicate goto 136
all_or_any_predicate goto 137
existence_test goto 138
function_ref goto 71
parameter goto 72
state 161
update_statement_searched : UPDATE table SET assignment_commalist opt_where_clause . (105)
. reduce 105
state 162
base_table_def : CREATE TABLE . table '(' base_table_element_commalist ')'
NAME shift 42
table goto 209
state 163
view_def : CREATE VIEW . table opt_column_commalist AS query_spec opt_with_check_option
NAME shift 42
table goto 210
state 164
privileges : ALL . PRIVILEGES
privileges : ALL . (45)
PRIVILEGES shift 211
. reduce 45
state 165
operation : DELETE . (51)
. reduce 51
state 166
operation : INSERT . (50)
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -