Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-25156

2845574Aug 31 2015 — edited Aug 31 2015

Hi Masters,

I have two table and i joined using full outer join based on some condition. but i got error like

ORA-25156: old style outer join cannot be used with ANSI joins

25156. 00000 -  "old style outer join cannot be used with ANSI joins"

I have given by query below

select JOIN_TAB.NAME_J,JOIN_TAB.ID_J,

JOIN_TAB1.NAME_J1,JOIN_TAB1.ID_J1

from

join_tab

full outer join

join_tab1

on JOIN_TAB.ID_J = JOIN_TAB1.ID_J1(+)

where JOIN_TAB.ID_J(+) = 1

;

is there any mistake on above query if so please guide me to solve that?

thanks in advanced

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2015
Added on Aug 31 2015
4 comments
2,224 views