在oracle中创建表时生成错误 [英] Error generated while creating table in oracle

问题描述

我正在编写以下语句在oracle数据库中创建表，但无法创建表.生成一个错误，称为

ORA-00904::无效的标识符

我已经在oracle create table中编写了以下代码来创建表

SYSTEM.UserLogin(在线号(1)为null，角色varchar2(15)为null)

我正在使用Oracle 10g Express Edition.

I am writing following statement to create a table in oracle database but failed to create table. An error is generated called

ORA-00904: : invalid identifier

I had written following code to create table in oracle create table

SYSTEM.UserLogin (Online number(1) null , Role varchar2(15) null )

I am using Oracle 10g express edition.

推荐答案

如果您用Googled搜索ORA-00904并遵循了第一个链接，您将看到以下内容:

If you Googled ORA-00904 and followed the first link, you would have seen this:

ORA-00904:	string: invalid identifier

Cause:	                The column name entered is either missing or invalid.

Action:                 Enter a valid column name. A valid column name must 
                        begin with a letter, be less than or equal to 30 
                        characters, and consist of only alphanumeric characters
                        and the special characters

，_和#.如果它 包含其他字符，则必须将其括起来 用双引号引起来.可能不是 保留字.

, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.

如果您看到最后一句话它可能不是保留字"，那么您将在Google中搜索"Oracle保留字"，在第一个链接上，您会看到 role 和在线是保留字.

If you saw the last sentence "It may not be a reserved word", then you would have Googled "Oracle reserved words", and on the first link you would have seen that both role and online are reserved words.

这篇关于在oracle中创建表时生成错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！