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: Rows/no rows

Re: Rows/no rows

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 23 Aug 2007 12:51:18 -0700
Message-ID: <1187898678.481201.43430@r23g2000prd.googlegroups.com>


On Aug 23, 3:30 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> Something weird happened, the first query retruns rows but not the second
> Have you an explanation ? ( 9.2.0.6 AIX)
>
> Thanks in advance
>
> select * from
> V_PROD_INT S_PROD_INT,
> S_PROD_INT PR_EQUIV,
> S_ORG_EXT
> WHERE
> S_PROD_INT.PR_EQUIV_PROD_ID = PR_EQUIV.ROW_ID(+) AND
> S_PROD_INT.VENDR_OU_ID = S_ORG_EXT.ROW_ID(+)
>
> select S_PROD_INT.row_id from
> V_PROD_INT S_PROD_INT,
> S_PROD_INT PR_EQUIV,
> S_ORG_EXT
> WHERE
> S_PROD_INT.PR_EQUIV_PROD_ID = PR_EQUIV.ROW_ID(+) AND
> S_PROD_INT.VENDR_OU_ID = S_ORG_EXT.ROW_ID(+)
S_PROD_INT PR_EQUIV Received on Thu Aug 23 2007 - 14:51:18 CDT

Original text of this message

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