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(+)
解决方案 »
- 高分求助
- 求一个SQL语句,或者给出举例也可,急中
- 更改数据库的参数问题~~
- 我在本地创建好了一个数据库,可就是连不上???急!!!
- 表空间并未用满,表却怎么也无法执行insert语句了?
- 求Oracle中的对应操作:在SqlServer中把一个bigint型的字段设为“标识”
- 请问:在oracle的存储过程里,我想访问另外一个用户的表,该怎么写?
- 如何使用C#上传图片到ORACLE中,然后在需要的时候取出呢?谢谢(目前只有这么多分分勒,有了再加)
- Oracle中有一对多、多对一的关系吗?怎样读取关系?
- 救急!!!after logon on database
- 请问这种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