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