PL/SQL (MOSC)

MOSC Banner

query result showing diff

edited Nov 11, 2018 5:21AM in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi

Both queries are left outer join query.... but results are different.... please suggest me.. what reason  is it?

version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

            :PL/SQL Release 12.1.0.2.0 - Production

Query-1

select m.*, sm.suname from POWDER_COAT_MAST m  left OUTER JOIN Supplier sm ON sm.sucode = m.sucode and m.company_id = sm.company_idand m.Serial_No like '%' || :refNo ||'%'and m.Issue_RefNo like '%' || :IssueRefNo ||'%'and m.SuCode like '%' || :sucode ||'%'and nvl(m.Delnote_No,'*') like '%' || :DelnoteNo ||'%'and nvl(m.Sup_InvNo,'*') like '%' || :InvNo ||'%'and nvl(m.Details,'*') like '%' || :Details ||'%'and m.posted like '%' || :posted || '%'Order by m.COMPANY_ID, m.SERIAL_NO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center