Oracle创建表格时报错ora-00903:表名无效

当我在数据库中创建order表时，系统提示

ora-00903:表名无效

create table ORDER
(
  oid        NUMBER,
  bid        NUMBER,
  createdate VARCHAR2(50),
  count      NUMBER,
  price      VARCHAR2(50),
  totalprice VARCHAR2(50),
  state      NUMBER
)

原来，order是系统保留字，所以我将order改为es_order，再运行就成功了。

oracle的保留字有很多，所以，创建表格的时候为了避免以上错误，最好以xx_xx的格式（个人建议）

Oracle的保留字可以在以DBA身份登录的情况下，通过select * from v$reserved_words order by keyword asc;语句来获得

//by keyword asc 是为了排序

然后在PL/SQL的SQL Window中获取结果后，

点击绿色向下箭头，将 结果显示在一页上 ，然后在结果空白处右击----》Export results----》Html file将其导出，以便以后查阅。

保留字如下：

&
|
:
,
-
=
>
[
<
(
.
+
]
)
!
/
*
^
@
ABORT
ACCESS
ACCESSED
ACCOUNT
ACTIVATE
ADD
ADMIN
ADMINISTER
ADMINISTRATOR
ADVISE
AFTER
ALGORITHM
ALIAS
ALL
ALL_ROWS
ALLOCATE
ALLOW
ALTER
ALWAYS
ANALYZE
ANCILLARY
AND
ANY
APPLY
ARCHIVE
ARCHIVELOG
ARRAY
AS
ASC
ASSOCIATE
AT
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHENTICATED
AUTHID
AUTHORIZATION
AUTO
AUTOALLOCATE
AUTOEXTEND
AUTOMATIC
AVAILABILITY
BACKUP
BECOME
BEFORE
BEGIN
BEHALF
BETWEEN
BFILE
BINDING
BITMAP
BITS
BLOB
BLOCK
BLOCKSIZE
BLOCK_RANGE
BODY
BOUND
BOTH
BROADCAST
BUFFER_POOL
BUILD
BULK
BY
BYTE
CACHE
CACHE_INSTANCES
CALL
CANCEL
CASCADE
CASE
CAST
CATEGORY
CERTIFICATE
CFILE
CHAINED
CHANGE
CHAR
CHAR_CS
CHARACTER
CHECK
CHECKPOINT
CHILD
CHOOSE
CHUNK
CLASS
CLEAR
CLOB
CLONE
CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER
COALESCE
COLLECT
COLUMN
COLUMNS
COLUMN_VALUE
COMMENT
COMMIT
COMMITTED
COMPATIBILITY
COMPILE
COMPLETE
COMPOSITE_LIMIT
COMPRESS
COMPUTE
CONFORMING
CONNECT
CONNECT_TIME
CONSIDER
CONSISTENT
CONSTRAINT
CONSTRAINTS
CONTAINER
CONTENTS
CONTEXT
CONTINUE
CONTROLFILE
CONVERT
CORRUPTION
COST
CPU_PER_CALL
CPU_PER_SESSION
CREATE
CREATE_STORED_OUTLINES
CROSS
CUBE
CURRENT
CURRENT_DATE
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CURSOR_SPECIFIC_SEGMENT
CYCLE
DANGLING
DATA
DATABASE
DATAFILE
DATAFILES
DATAOBJNO
DATE
DATE_MODE
DAY
DBA
DBTIMEZONE
DDL
DEALLOCATE
DEBUG
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DEFINED
DEFINER
DEGREE
DELAY
DELETE
DEMAND
DENSE_RANK
ROWDEPENDENCIES
DEREF
DESC
DETACHED
DETERMINES
DICTIONARY
DIMENSION
DIRECTORY
DISABLE
DISASSOCIATE
DISCONNECT
DISK
DISKGROUP
DISKS
DISMOUNT
DISPATCHERS
DISTINCT
DISTINGUISHED
DISTRIBUTED
DML
DOUBLE
DROP
DUMP
DYNAMIC
EACH
ELEMENT
ELSE
ENABLE
ENCRYPTED
ENCRYPTION
END
ENFORCE
ENTRY
ERROR_ON_OVERLAP_TIME
ESCAPE
ESTIMATE
EVENTS
EXCEPT
EXCEPTIONS
EXCHANGE
EXCLUDING
EXCLUSIVE
EXECUTE
EXEMPT
EXISTS
EXPIRE
EXPLAIN
EXPLOSION
EXTEND
EXTENDS
EXTENT
EXTENTS
EXTERNAL
EXTERNALLY
EXTRACT
FAILED_LOGIN_ATTEMPTS
FAILGROUP
FALSE
FAST
FILE
FILTER
FINAL
FINISH
FIRST
FIRST_ROWS
FLAGGER
FLASHBACK
FLOAT
FLOB
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN
FREELIST
FREELISTS
FREEPOOLS
FRESH
FROM
FULL
FUNCTION
FUNCTIONS
GENERATED
GLOBAL
GLOBALLY
GLOBAL_NAME
GLOBAL_TOPIC_ENABLED
GRANT
GROUP
GROUPING
GROUPS
GUARANTEED
GUARD
HASH
HASHKEYS
HAVING
HEADER
HEAP
HIERARCHY
HOUR
ID
IDENTIFIED
IDENTIFIER
IDGENERATORS
IDLE_TIME
IF
IMMEDIATE
IN
INCLUDING
INCREMENT
INCREMENTAL
INDEX
INDEXED
INDEXES
INDEXTYPE
INDEXTYPES
INDICATOR
INITIAL
INITIALIZED
INITIALLY
INITRANS
INNER
INSERT
INSTANCE
INSTANCES
INSTANTIABLE
INSTANTLY
INSTEAD
INT
INTEGER
INTEGRITY
INTERMEDIATE
INTERNAL_USE
INTERNAL_CONVERT
INTERSECT
INTERVAL
INTO
INVALIDATE
IN_MEMORY_METADATA
IS
ISOLATION
ISOLATION_LEVEL
JAVA
JOIN
KEEP
KERBEROS
KEY
KEYFILE
KEYS
KEYSIZE
REKEY
KILL
<<
LAST
LATERAL
LAYER
LDAP_REGISTRATION
LDAP_REGISTRATION_ENABLED
LDAP_REG_SYNC_INTERVAL
LEADING
LEFT
LESS
LEVEL
LEVELS
LIBRARY
LIKE
LIKE2
LIKE4
LIKEC
LIMIT
LINK
LIST
LOB
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATION
LOCATOR
LOCK
LOCKED
LOG
LOGFILE
LOGGING
LOGICAL
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LOGOFF
LOGON
LONG
MANAGE
MANAGED
MANAGEMENT
MANUAL
MAPPING
MASTER
MATERIALIZED
MATCHED
MAX
MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS
MAXIMIZE
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXSIZE
MAXTRANS
MAXVALUE
METHOD
MIN
MEMBER
MEMORY
MERGE
MIGRATE
MINIMIZE
MINIMUM
MINEXTENTS
MINUS
MINUTE
MINVALUE
MIRROR
MLSLABEL
MODE
MODIFY
MONITORING
MONTH
MOUNT
MOVE
MOVEMENT
MTS_DISPATCHERS
MULTISET
NAME
NAMED
NATIONAL
NATURAL
NCHAR
NCHAR_CS
NCLOB
NEEDED
NESTED
NESTED_TABLE_ID
NETWORK
NEVER
NEW
NEXT
NLS_CALENDAR
NLS_CHARACTERSET
NLS_COMP
NLS_NCHAR_CONV_EXCP
NLS_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_ISO_CURRENCY
NLS_LANG
NLS_LANGUAGE
NLS_LENGTH_SEMANTICS
NLS_NUMERIC_CHARACTERS
NLS_SORT
NLS_SPECIAL_CHARS
NLS_TERRITORY
NO
NOARCHIVELOG
NOAUDIT
NOCACHE
NOCOMPRESS
NOCYCLE
NOROWDEPENDENCIES
NODELAY
NOFORCE
NOLOGGING
NOMAPPING
NOMAXVALUE
NOMINIMIZE
NOMINVALUE
NOMONITORING
NONE
NOORDER
NOOVERRIDE
NOPARALLEL
NORELY
NOREPAIR
NORESETLOGS
NOREVERSE
NORMAL
NOSEGMENT
NOSTRICT
NOSTRIPE
NOSORT
NOSWITCH
NOT
NOTHING
NOVALIDATE
NOWAIT
NULL
NULLS
NUMBER
NUMERIC
NVARCHAR2
OBJECT
OBJNO
OBJNO_REUSE
OF
OFF
OFFLINE
OID
OIDINDEX
OLD
ON
ONLINE
ONLY
OPAQUE
OPCODE
OPEN
OPERATOR
OPTIMAL
OPTIMIZER_GOAL
OPTION
OR
ORDER
ORGANIZATION
OUTER
OUTLINE
OVER
OVERFLOW
OVERLAPS
OWN
PACKAGE
PACKAGES
PARALLEL
PARAMETERS
PARENT
PARITY
PARTIALLY
PARTITION
PARTITIONS
PARTITION_HASH
PARTITION_LIST
PARTITION_RANGE
PASSWORD
PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION
PCTFREE
PCTINCREASE
PCTTHRESHOLD
PCTUSED
PCTVERSION
PERCENT
PERFORMANCE
PERMANENT
PFILE
PHYSICAL
PLAN
PLSQL_DEBUG
POLICY
POST_TRANSACTION
PREBUILT
PRECEDING
PRECISION
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVATE
PRIVATE_SGA
PRIVILEGE
PRIVILEGES
PROCEDURE
PROFILE
PROTECTED
PROTECTION
PUBLIC
PURGE
PX_GRANULE
QUERY
QUEUE
QUIESCE
QUOTA
RANDOM
RANGE
RAPIDLY
RAW
RBA
READ
READS
REAL
REBALANCE
REBUILD
RECORDS_PER_BLOCK
RECOVER
RECOVERABLE
RECOVERY
RECYCLE
REDUCED
REF
REFERENCES
REFERENCING
REFRESH
REGISTER
REJECT
RELATIONAL
RELY
RENAME
REPAIR
REPLACE
RESET
RESETLOGS
RESIZE
RESOLVE
RESOLVER
RESOURCE
RESTRICT
RESTRICTED
RESUMABLE
RESUME
RETENTION
RETURN
RETURNING
REUSE
REVERSE
REVOKE
REWRITE
RIGHT
ROLE
ROLES
ROLLBACK
ROLLUP
ROW
ROWID
ROWNUM
ROWS
RULE
SAMPLE
SAVEPOINT
SB4
SCAN
SCAN_INSTANCES
SCHEMA
SCN
SCOPE
SD_ALL
SD_INHIBIT
SD_SHOW
SECOND
SECURITY
SEGMENT
SEG_BLOCK
SEG_FILE
SELECT
SELECTIVITY
SEQUENCE
SEQUENCED
SERIALIZABLE
SERVERERROR
SESSION
SESSION_CACHED_CURSORS
SESSIONS_PER_USER
SESSIONTIMEZONE
SESSIONTZNAME
SET
SETS
SETTINGS
SHARE
SHARED
SHARED_POOL
SHRINK
SHUTDOWN
SIBLINGS
SID
SINGLE
SINGLETASK
SIMPLE
SIZE
SKIP
SKIP_UNUSABLE_INDEXES
SMALLINT
SNAPSHOT
SOME
SORT
SOURCE
SPACE
SPECIFICATION
SPFILE
SPLIT
SQL_TRACE
STANDBY
START
STARTUP
STATEMENT_ID
STATISTICS
STATIC
STOP
STORAGE
STORE
STRIPE
STRICT
STRUCTURE
SUBPARTITION
SUBPARTITIONS
SUBPARTITION_REL
SUBSTITUTABLE
SUCCESSFUL
SUMMARY
SUSPEND
SUPPLEMENTAL
SWITCH
SWITCHOVER
SYS_OP_BITVEC
SYS_OP_COL_PRESENT
SYS_OP_CAST
SYS_OP_ENFORCE_NOT_NULL$
SYS_OP_MINE_VALUE
SYS_OP_NOEXPAND
SYS_OP_NTCIMG$
SYNONYM
SYSDATE
SYSDBA
SYSOPER
SYSTEM
SYSTIMESTAMP
TABLE
TABLES
TABLESPACE
TABLESPACE_NO
TABNO
TEMPFILE
TEMPLATE
TEMPORARY
TEST
THAN
THE
THEN
THREAD
THROUGH
TIMESTAMP
TIME
TIMEOUT
TIMEZONE_ABBR
TIMEZONE_HOUR
TIMEZONE_MINUTE
TIMEZONE_REGION
TIME_ZONE
TO
TOPLEVEL
TRACE
TRACING
TRAILING
TRANSACTION
TRANSITIONAL
TREAT
TRIGGER
TRIGGERS
TRUE
TRUNCATE
TX
TYPE
TYPES
TZ_OFFSET
UB2
UBA
UID
UNARCHIVED
UNBOUND
UNBOUNDED
UNDER
UNDO
UNDROP
UNIFORM
UNION
UNIQUE
UNLIMITED
UNLOCK
UNPACKED
UNPROTECTED
UNQUIESCE
UNRECOVERABLE
UNTIL
UNUSABLE
UNUSED
UPD_INDEXES
UPD_JOININDEX
UPDATABLE
UPDATE
UPGRADE
UROWID
USAGE
USE
USE_PRIVATE_OUTLINES
USE_STORED_OUTLINES
USER
USER_DEFINED
USING
VALIDATE
VALIDATION
VALUE
VALUES
VARCHAR
VARCHAR2
VARRAY
VARYING
VERSION
VIEW
WAIT
WHEN
WHENEVER
WHERE
WITH
WITHIN
WITHOUT
WORK
WRAPPED
WRITE
XMLATTRIBUTES
XMLCOLATTVAL
XMLELEMENT
XMLFOREST
XMLTYPE
XMLSCHEMA
XID
YEAR
ZONE