关键字¶
下表列出了神通数据库系统中所有的关键字,RESERVED属性为true则表示对应的KEYWORD为保留关键字:
| KEYWORD | RESERVED |
|---|---|
| abort | false |
| absolute | false |
| access | false |
| accessed | false |
| action | false |
| add | false |
| adddate | false |
| admin | false |
| advisor | false |
| after | false |
| aggregate | false |
| all | true |
| alter | false |
| always | false |
| analyse | false |
| analyze | false |
| analyzer | false |
| and | true |
| any | true |
| app | false |
| archive | false |
| archivelog | false |
| are | false |
| array | false |
| as | true |
| asc | false |
| assertion | false |
| assignment | false |
| ast | false |
| async | false |
| at | true |
| attributes | false |
| audit | false |
| auditfile | false |
| authid | false |
| authorization | false |
| auto | false |
| auto_increment | false |
| autoextend | false |
| backup | false |
| backward | false |
| basicanalyzer | false |
| batchsize | false |
| before | false |
| begin | false |
| between | false |
| bigint | false |
| binary | false |
| binaryencrypted | false |
| binlog | false |
| bit | false |
| bitmap | false |
| block | false |
| body | false |
| boolean | false |
| both | false |
| bpchar | false |
| buffer | false |
| buffer_cache | false |
| buffer_pool | false |
| build | false |
| bulk | false |
| by | false |
| byte | false |
| cache | false |
| call | false |
| called | false |
| cancel | false |
| cascade | true |
| cascaded | false |
| case | true |
| caseinsensitive | true |
| casesensitive | true |
| cast | true |
| cdc | false |
| chain | false |
| change | false |
| char | true |
| character | true |
| characteristics | false |
| characterset | false |
| cheat | false |
| check | true |
| check_constraints | true |
| checkpoint | false |
| chineseanalyzer | false |
| chunk | false |
| cjkanalyzer | false |
| class | false |
| clean | false |
| close | false |
| cluster | false |
| coalesce | true |
| codepage | true |
| collate | true |
| column | true |
| columns | false |
| comment | false |
| comments | false |
| commit | false |
| committed | false |
| compile | false |
| complete | false |
| compress | false |
| concat | false |
| configuration | false |
| connect | false |
| connect_by_iscycle | false |
| connect_by_isleaf | false |
| connect_by_root | false |
| constraint | true |
| constraints | false |
| constructor | true |
| content | false |
| context | false |
| continue | false |
| controlfile | false |
| conversion | false |
| convert | true |
| convert | true |
| copy | false |
| create | true |
| cross | false |
| csv | false |
| cube | false |
| current | false |
| current_time | true |
| current_timestamp | true |
| current_user | false |
| cursor | false |
| cycle | false |
| data | false |
| database | false |
| databaselink | false |
| datafile | false |
| datafiletype | false |
| date | false |
| date_add | false |
| date_sub | false |
| dateformat | false |
| datetime | false |
| day | false |
| dba | false |
| deallocate | false |
| debug | false |
| dec | false |
| decimal | true |
| declare | false |
| decode | false |
| decrypt | false |
| default | true |
| deferrable | false |
| deferred | false |
| definer | false |
| delete | false |
| delimited | false |
| delimiter | false |
| delimiters | false |
| demand | false |
| dense_rank | false |
| desc | false |
| description | false |
| deterministic | false |
| directory | false |
| disable | false |
| distinct | true |
| do | true |
| document | false |
| domain | false |
| double | false |
| drop | true |
| dump | false |
| each | false |
| elog | false |
| else | true |
| elt | false |
| empty | false |
| enable | false |
| encoding | false |
| encrypt | false |
| encrypted | false |
| encryption | false |
| end | false |
| error | false |
| errors | false |
| escalation | false |
| escape | false |
| events | false |
| except | true |
| exchange | false |
| exclude | false |
| excluding | false |
| exclusive | false |
| exec | false |
| execute | false |
| exists | true |
| explain | false |
| export | false |
| extend | false |
| external | true |
| externally | false |
| extract | true |
| failover | false |
| false | false |
| far | false |
| fast | false |
| fault | false |
| fetch | false |
| field | false |
| fields | false |
| fieldterminator | false |
| file | false |
| filesize | false |
| fill | false |
| filter | false |
| fire_triggers | false |
| first | false |
| firstrow | false |
| flashback | true |
| float | true |
| flush | false |
| following | false |
| for | true |
| force | false |
| foreign | true |
| foreignkey_constraints | false |
| forever | false |
| formatfile | false |
| forward | false |
| freelists | false |
| freepools | false |
| from | true |
| full | false |
| fulltext | false |
| function | false |
| g | false |
| gb | false |
| gbk | false |
| gcov | false |
| generated | false |
| geography | false |
| geometry | false |
| get | false |
| getclobval | false |
| getstringval | false |
| global | false |
| global_name | false |
| globally | false |
| grant | true |
| greatest | false |
| group | true |
| grouping | false |
| grouping_id | false |
| guarantee | false |
| handler | false |
| hash | false |
| having | true |
| header | false |
| heap | false |
| hold | false |
| hour | false |
| identified | false |
| identity | false |
| if | false |
| ignore | false |
| ilike | false |
| immediate | false |
| immutable | false |
| implicit | false |
| import | false |
| import_polcol | false |
| in | true |
| include | true |
| including | true |
| increment | false |
| index | false |
| indexes | false |
| inherits | false |
| init | false |
| initial | false |
| initialized | false |
| initially | false |
| initrans | false |
| inner | false |
| inout | false |
| input | false |
| insensitive | false |
| insert | false |
| instead | false |
| int | true |
| integer | true |
| intersect | true |
| interval | false |
| into | true |
| invalidate | false |
| invisible | false |
| invoker | false |
| ip | false |
| is | false |
| isnull | false |
| isolation | false |
| join | false |
| json | false |
| json_table | false |
| json_value | false |
| k | false |
| kb | false |
| keep | false |
| keepidentity | false |
| keepnulls | false |
| key | false |
| keystore | false |
| kill | false |
| kilobytes_per_batch | false |
| kstore | false |
| label | false |
| lancompiler | false |
| language | false |
| last | false |
| lastrow | false |
| latch | false |
| lc_collate | false |
| lc_ctype | false |
| ldrtrim | false |
| leading | false |
| leak | false |
| least | false |
| left | false |
| less | false |
| level | true |
| lifetime | false |
| like | false |
| limit | false |
| list | false |
| listen | false |
| load | false |
| lob | false |
| local | false |
| localtime | true |
| localtimestamp | true |
| location | false |
| lock | false |
| locked | false |
| log | false |
| logfile | false |
| logging | false |
| logical | false |
| long | false |
| loop | false |
| lrtrim | false |
| lsn | false |
| ltrim | false |
| m | false |
| maintain_index | false |
| maintenance | false |
| manual | false |
| masking | false |
| master | false |
| match | false |
| matched | false |
| materialized | false |
| max | false |
| maxerrors | false |
| maxextends | false |
| maxextents | false |
| maxsize | false |
| maxtrans | false |
| maxvalue | false |
| mb | false |
| member | false |
| memory | false |
| merge | false |
| min | false |
| minextends | false |
| minextents | false |
| minsize | false |
| minus | false |
| minute | false |
| minvalue | false |
| missing | false |
| mod | false |
| mode | false |
| modify | false |
| money | false |
| month | false |
| mount | false |
| move | false |
| movement | false |
| multicolumn | false |
| multiple | false |
| name | false |
| names | false |
| national | true |
| natural | false |
| nchar | false |
| never | false |
| new | true |
| newline | false |
| next | false |
| nextval | false |
| no | false |
| noarchivelog | false |
| noaudit | false |
| nocache | false |
| nocompress | false |
| nocopy | false |
| nocycle | false |
| node | false |
| noguarantee | false |
| nologging | false |
| nomaxvalue | false |
| nominvalue | false |
| nomount | false |
| none | true |
| norecompute | true |
| normal | false |
| not | true |
| nothing | false |
| notify | false |
| notnull | false |
| notrim | false |
| novalidate | false |
| nowait | false |
| null | true |
| nullif | true |
| nulls | true |
| number | true |
| numeric | true |
| nvarchar2 | false |
| nvl | false |
| nvl2 | false |
| object | false |
| of | false |
| off | false |
| offline | false |
| offset | false |
| oids | false |
| old | true |
| on | true |
| online | false |
| only | true |
| open | false |
| operator | false |
| optimize | false |
| optimize_kscache | false |
| option | false |
| or | true |
| oracle | false |
| order | true |
| ordinality | false |
| organization | false |
| oscar | false |
| out | false |
| outer | false |
| outline | false |
| over | false |
| overflow | false |
| overlaps | false |
| overlay | false |
| owner | false |
| package | false |
| pagesize | false |
| parallel | false |
| parameter | false |
| parameters | true |
| paraminfo | false |
| partial | false |
| partition | false |
| partitions | false |
| passing | false |
| password | false |
| path | false |
| pctfree | false |
| pctincrease | false |
| pctthreshold | false |
| pctused | false |
| pctversion | false |
| pendant | false |
| percent | true |
| petention | false |
| pfile | false |
| pipelined | false |
| pivot | false |
| placing | false |
| pls_integer | false |
| policy | false |
| port | false |
| position | false |
| preceding | false |
| precision | false |
| prepare | false |
| preserve | false |
| preval | false |
| primary | false |
| prior | false |
| priority | false |
| privileges | false |
| procedural | false |
| procedure | false |
| public | false |
| purge | false |
| qu | false |
| query | false |
| quick | false |
| quote | false |
| rac | false |
| range | false |
| ratio_to_report | false |
| raw | false |
| read | false |
| readable | false |
| reads | false |
| readsize | false |
| real | true |
| rebuild | false |
| recheck | false |
| records | false |
| recovery | false |
| recreate | false |
| recursive | false |
| recycle | false |
| recyclebin | true |
| redo | true |
| references | true |
| referencing | true |
| refresh | false |
| regexp | false |
| region | false |
| reject | false |
| relative | false |
| remove | false |
| rename | false |
| repeatable | false |
| replace | false |
| reset | false |
| resize | false |
| resource | false |
| restart | false |
| restore | false |
| restrict | false |
| result | false |
| resume | false |
| retention | false |
| return | false |
| return_generated_keys | false |
| returning | false |
| returns | false |
| reuse | false |
| reverse | false |
| revoke | false |
| rewrite | false |
| right | false |
| role | false |
| rollback | false |
| rollup | false |
| row | false |
| rowdescription | false |
| rowid | false |
| rows | false |
| rows_per_batch | false |
| rowterminator | false |
| rowtype | false |
| rtrim | false |
| rule | false |
| sample | false |
| savepoint | false |
| scan | false |
| schema | false |
| scn | false |
| scroll | false |
| second | false |
| security | false |
| segment | false |
| select | true |
| separator | false |
| sequence | false |
| serializable | false |
| session | false |
| set | true |
| setof | true |
| sets | false |
| share | false |
| show | false |
| shrink | false |
| shrinklog | false |
| shutdown | false |
| siblings | false |
| signed | false |
| silently | false |
| similar | false |
| simple | false |
| single | false |
| singlerow | false |
| size | false |
| skip | false |
| smallint | false |
| some | true |
| space | false |
| specification | true |
| split | false |
| stable | false |
| standalone | false |
| standardanalyzer | false |
| start | false |
| startfile | false |
| startpos | false |
| starttime | false |
| startup | false |
| statement | false |
| static | false |
| statistics | false |
| stdin | false |
| stdout | false |
| stop | false |
| stopfile | false |
| stoppos | false |
| stoptime | false |
| stopwords | false |
| storage | false |
| store | false |
| stored | false |
| strict | false |
| subpartition | false |
| subpartitions | false |
| substring | false |
| successful | false |
| suspend | false |
| switchover | false |
| sync | false |
| synonym | true |
| sys_connect_by_path | true |
| sysaux | false |
| sysauxfile | false |
| sysid | false |
| system | false |
| t | false |
| table | true |
| tablespace | false |
| tablock | true |
| tb | false |
| temp | false |
| tempfile | false |
| template | false |
| temporary | false |
| terminated | false |
| than | false |
| then | true |
| thread | true |
| time | true |
| times | false |
| timestamp | true |
| timezone | false |
| tinyint | false |
| to | true |
| toast | false |
| top | true |
| trace | false |
| tracking | false |
| trail | false |
| trailing | false |
| transaction | false |
| transactional | false |
| transforms | false |
| treat | false |
| trial | false |
| trigger | false |
| triggers | false |
| trim | false |
| true | false |
| truncate | false |
| trusted | false |
| tuple | false |
| type | false |
| unbounded | false |
| uncommitted | false |
| undo | false |
| unencrypted | false |
| union | true |
| unique | true |
| unknown | false |
| unlimited | false |
| unlisten | false |
| unlock | false |
| unmaintenance | false |
| unpivot | false |
| unsigned | false |
| until | false |
| unusable | false |
| up | false |
| update | false |
| updatelabel | false |
| updatexml | false |
| usage | false |
| use | false |
| user | false |
| using | true |
| utf8 | false |
| utf8mb4 | false |
| vacuum | false |
| valid | false |
| validate | false |
| validation | false |
| validator | false |
| value | false |
| values | false |
| varbinary | false |
| varbit | false |
| varchar | false |
| varchar2 | false |
| varying | false |
| verbose | false |
| version | false |
| versions | false |
| view | false |
| virtual | false |
| visible | false |
| volatile | false |
| votedisk | false |
| wait | false |
| wallet | false |
| weight | false |
| when | false |
| whenever | false |
| where | true |
| window | false |
| with | true |
| within | true |
| without | true |
| work | false |
| write | true |
| xml | false |
| xmlattributes | false |
| xmlconcat | false |
| xmlelement | false |
| xmlforest | false |
| xmlparse | false |
| xmlpi | false |
| xmlroot | false |
| xmlserialize | false |
| xmltable | false |
| year | false |
| yes | false |
| zone | false |