ORA-1747 error 求助。 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ORA-1747 error 求助。

ORA-1747 error 求助。# Database - 数据库

c*c2008-09-08 07:09

1 楼

不知道为啥一个table的column给命名为 number而且是primary key。结果我没法选了
select * from activities where number = '123456'。结果得到ORA-1747错误。用“
number”也不行。得到ORA-00904错误
没法重命名number，所有applications都用，那样改动实在太大。
怎么写query，谢谢

w*r2008-09-08 07:09

2 楼

"number"=12

【在 c***c 的大作中提到】

: 不知道为啥一个table的column给命名为 number而且是primary key。结果我没法选了
: select * from activities where number = '123456'。结果得到ORA-1747错误。用“
: number”也不行。得到ORA-00904错误
: 没法重命名number，所有applications都用，那样改动实在太大。
: 怎么写query，谢谢

c*c2008-09-08 07:09

3 楼

google来的
http://www.dba-oracle.com/t_ora_01747_invalid_user_table_column_table_column_or_column_specification.htm
ORA-01747 appears in Oracle MetaLink documents as an issue that occurs when
reservations are off. Here is an example of the error stemming from Pick
Release log file:
oe-e-oesupl ORA-01747 invalid user.table.column, table.column or column
specification
oe-e-oesupl sql occured while trying to select picking lines from
picking
header.
To resolve ORA-01747 in this case,

【在 w*r 的大作中提到】

: "number"=12

w*r2008-09-08 07:09

4 楼

BUG!

oracle.com/t_ora_01747_invalid_user_table_column_table_column_or_column_
specifi
cation.htm
when
column

【在 c***c 的大作中提到】

: google来的
: http://www.dba-oracle.com/t_ora_01747_invalid_user_table_column_table_column_or_column_specification.htm
: ORA-01747 appears in Oracle MetaLink documents as an issue that occurs when
: reservations are off. Here is an example of the error stemming from Pick
: Release log file:
: oe-e-oesupl ORA-01747 invalid user.table.column, table.column or column
: specification
: oe-e-oesupl sql occured while trying to select picking lines from
: picking
: header.

c*c2008-09-08 07:09

5 楼

I figure it out
I should use
select * from table_name where "NUMBER" = '123456'。All upper case.
这是思维误区，总认为Oracle里没有case sensitive

【在 w*r 的大作中提到】

: BUG!
:
: oracle.com/t_ora_01747_invalid_user_table_column_table_column_or_column_
: specifi
: cation.htm
: when
: column