SELECT A.IP, B.TIME,C.TIME,D.TIME
FROM A,B,C,D
WHERE A.IP=B.IP(+)
AND A.IP=C.IP(+)
AND A.IP=D.IP(+)
FROM A,B,C,D
WHERE A.IP=B.IP(+)
AND A.IP=C.IP(+)
AND A.IP=D.IP(+)
解决方案 »
- 500W条数据 快速插入,快速查询。
- ORA-01017???
- 在eclipse中做个插入语句,插入到oracle中,其中一个列是Date类型,在eclipse中传什么样的值能添加进去?
- ado打开Oracle的程序的路径为什么不能包含右括号')'
- 备份失败信息( VNI-2015 : 目标节点的节点首选身份证明无效 )
- 请问oracle中如何设置主键id为自增,本人刚学,比较菜,高手帮帮忙呀!!!
- 如何显示将某个日期的字段加上3年后的结果?
- 与SQLSERVER类似的“事件跟踪”程序在那里找到,散分。。。。
- 这个存储过程怎么写?
- 请问oracle 中pl/sql的语法帮助从那里可以找到呀
- 请问这种SQL语句怎么写?
- oracle给表增加字段的语句?
Create View myview SELECT lin_winip.IP_addr, iptpc_host_cpu.Max(indb_time) As cpu,iptpc_host_memory.Max(indb_time) As memory,
iptpc_host_filesys.max(indb_time) As filesys
FROM lin_winip,iptpc_host_cpu,iptpc_host_memory,iptpc_host_filesys
WHERE lin_winip.ip_addr=iptpc_host_cpu.ip_addr(+)
AND lin_winip.ip_addr=iptpc_host_memory.ip_addr(+)
AND lin_winip.ip_addr=iptpc_host_filesys.ip_addr(+) 报错:ora-00905 missing keyword
as select lin_winip.ip_addr,iptpc_host_cpu.max(indb_time),iptpc_host_memory.max(indb_time),iptpc_host_filesys.max(indb_time)
from (((lin_winip left JOIN iptpc_host_cpu on lin_winip.ip_addr = iptpc_host_cpu.ip_addr)
left join iptpc_host_memory on lin_winip.ip_addr = iptpc_host_memory.ip_addr)
left JOIN iptpc_host_filesys ON lin_winip.ip_addr = iptpc_host_filesys.ip_addr) group by lin_winip.ip_addr
go
select * from myview
drop view myview今天这么写报错sql command not properly ended
谁能帮我修改下么 我用的数据库是oracle