substitute your ourter join for that one:

where a.idext=b.id(+);

Suresh Kumar K. wrote:
> Hi Experts,
>
>
>
> I need solution for the below scenario.
>
>
>
> Table A (3 Lakh Records)
>
> Id number
>
> Col1 varchar2
>
> Col2 varchar2
>
> Col3 varchar2
>
> Idext number
>
>
>
> Table B (40K records)
>
> Id number
>
> Col1ext clob
>
> Col2ext clob
>
> Col3ext clob
>
>
>
> Table B is used when Table A record cannot hold values larger than
> varchar2, "idext" of Table A is used to establish relation with Table
> B's column "id"
>
>
>
> Here I need to create view which should have all the records of Table A
> and Table B with the following condition "where a.idext(+)=b.id" , the
> outer join is used also to include the records in Table A but no
> reference in B. But the created view doesn't include the records of
> Table A when it has no extension records in Table B.
>
>
>
> Please help me to resolve the problem.
>
>
>
> Thanks & Regards
>
> Suresh
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>



Oracle LazyDBA home page