在oracle中创建表时生成错误 | 在oracle中创建表时生成错误

本文介绍了在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.

推荐答案

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

如果您看到最后一句话它可能不是保留字"，那么您将在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中创建表时生成错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！