天道酬勤,学无止境

保留关键词表

Oracle 保留关键字——建表、别称都不能用的词

以下关键词用作别称时会报错[Err] ORA-00923: FROM keyword not found where expected 查询保留关键字表:select * from v$reserved_words 序号 KEYWORD LENGTH1 ! 12 & 13 ( 14 ) 15 * 16 + 17 , 18 - 19 . 110 / 111 : 112 < 113 << 214 = 115 > 116 @ 117 A 118 ABORT 519 ACCESS 620 ACCESSED 821 ACCOUNT 722 ACTIVATE 823 ADD 324 ADMIN 525 ADMINISTER 1026 ADMINISTRATOR 1327 ADVISE 628 ADVISOR 729 AFTER 530 ALGORITHM 931 ALIAS 532 ALL 333 ALLOCATE 834 ALLOW 535 ALL_ROWS 836 ALTER 537 ALWAYS 638 ANALYZE 739 ANCILLARY 940 AND 341 AND_EQUAL 942 ANTIJOIN 843 ANY 344 APPEND 645 APPLY 546 ARCHIVE 747 ARCHIVELOG 1048 ARRAY 549 AS 250 ASC 351

2021-03-27 10:53:11    分类:博客    保留关键字   保留关键词表   oracle甲骨文数据库