当前位置:数据库 > Oracle >>

Oracle sql报错,求解!!!!

sql如下: select trunc(tdate), sum(nvl(who_look, 0)), min(who_look_1_1), sum(nvl(who_look_1_2, 0)), sum(nvl(who_look_1_3, 0)), min(who_look_2_1), sum(nvl(who_look_2_2, 0)), sum(nvl(who_look_2_3, 0)), sum(nvl(profile, 0)), min(profile_1_1), sum(nvl(profile_1_2, 0)), sum(nvl(profile_1_3, 0)), min(profile_2_1), sum(nvl(profile_2_2, 0)), sum(nvl(profile_2_3, 0)), sum(nvl(ICON, 0)), min(ICON_1_1), sum(nvl(ICON_1_2, 0)), sum(nvl(ICON_1_3, 0)), min(ICON_2_1), sum(nvl(ICON_2_2, 0)), sum(nvl(ICON_2_3, 0)), sum(nvl(BANNER, 0)), min(BANNER_1_1), sum(nvl(BANNER_1_2, 0)), sum(nvl(BANNER_1_3, 0)), min(BANNER_2_1), sum(nvl(BANNER_2_2, 0)), sum(nvl(BANNER_2_3, 0)), min(KXBY_1), sum(nvl(KXBY_2, 0)), sum(nvl(KXBY_3, 0)), sum(nvl(PHOTO, 0)), min(PHOTO_1_1), sum(nvl(PHOTO_1_2, 0)), sum(nvl(PHOTO_1_3, 0)), min(PHOTO_2_1), sum(nvl(PHOTO_2_2, 0)), sum(nvl(PHOTO_2_3, 0)) from STATIST_VIP_BYSOURCE_ALL where TDATE >= trunc(sysdate) and tdate < trunc(sysdate +1) group by trunc(tdate) order by trunc(tdate) 报错如图:,谢谢
追问:表结构就是那些字段都是number类型的,太多了,列不出来字段是对的配置文件里面内容挺多的
答案:能把这个表结构看下吗?
其他:photo_2_3 此列无效 命令行下输入 lsnrctl Start 启动成功后在登录sqlplus就行了 检查一下你的ORACLE目录下的这个文件:tnsnames.ora是否配置正确。 文件内容: ORCL = ( 

上一个:知道oracle所在服务器的IP和数据库用户名,密码,怎么测能不能连上数库?
下一个:oracle数据库导入问题 输入用户和密码报错1017 提示无效的USER/PASSWORD 但是这个用户名密码能连上数据库

Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,