ORA-00904 invalid column nameCause: 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, it must be enclosed in
double quotation s. It may not be a reserved word.
than or equal to 30 characters, and consist of only alphanumeric characters and the
special characters $, _, and #. If it contains other characters, it must be enclosed in
double quotation s. It may not be a reserved word.
解决方案 »
- 这个sql语句如何写
- Oracle排序 先按推荐指数排,然后推荐指数高的,再按发布时间排序
- 第二次导入oracle备份数据无效,求解?
- 在本地计算机无法启动OracleDBConsoleorcl服务
- 如何将在别人机器oracle数据库上expdp导出的文件在我的机器oracle数据库导入进来 急
- database control-orcl是用来做什么的?
- 紧急求救!我在网上下载了一个plsqldev.exe文件,安装之后。。。。。。
- distributed transaction waiting for lock这是什么错误啊?急
- asp访问oracle错误 快来救命呀!!
- Oracle9i中shared memory realm does not exist是怎么回事??困扰好几个星期??Help Me??
- 请帮帮忙!如何设置oracle占用的内存?
- 客户端怎么连接连接不上服务器
谢谢!
ORA——01730,指定的列名数无效。
现在的SQL语句缩短了:
select b.casesymptomid,a.caseid,a.casename,c.symptomid,c.symptomname,c.symptomdescription,b.casesymptomproportion,d.equipmenttypecode,d.equipmenttypeid
from case a,case_symptom b,symptom c,equipment_type d
where a.caseid=b.caseid
and b.symptomid(+)=c.symptomid
and c.equipmenttypeid(+)=d.equipmenttypeid
是不是建视图时出错了?
就应该是这理
如果还是不对226512144QQ
[email protected]
和我联系好吗