Distributed Queries ...

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

Thanks
Rajesh Received on Fri Nov 20 1998 - 10:16:47 CST