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


Oracle LazyDBA home page