Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed Queries ...

Re: Distributed Queries ...

From: Jurij Modic <jmodic_at_src.si>
Date: Sat, 21 Nov 1998 23:40:02 GMT
Message-ID: <36574f43.68759308@news.arnes.si>


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)



The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Nov 21 1998 - 17:40:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US