Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed Queries ...
On Fri, 20 Nov 1998 21:46:47 +0530, Rajesh Bhave
<rajeshb_at_india.hp.com> wrote:
>Hi,
>
>Oracle SQL Manual mentions that below query will cause an error. Is it
>correct ? I think it will not cause any error.
>Consider that emp_ny do not have any LONG column.
>
>SELECT emp_ny.*
> FROM emp_ny_at_ny, dept
> WHERE emp_ny.deptno = dept.deptno
> AND dept.dname = ’ACCOUNTING’
> FOR UPDATE OF emp_ny.sal
No offence, Rajesh, but would it be to hard for you to type this same query into your SQL*Plus session and find out it's result instead of asking this in this newsgroup?
The manual you are refering to explicitely says this query will fail because the "FOR UPDATE" clasuse is not allowed on remote database - so if you don't belive it, then I sugest you try it and if you find the manual is wrong then report it as a documentation bug and/or report your findings in this newsgroup.
>Thanks
>Rajesh
Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)