Oracle Database Discussions

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!

How to convert sql query to oracle query?

955649Sep 13 2012 — edited Sep 13 2012

Hi all,

Hope doing well,

sir i am using oracle database where i am running my sql query in oracle. but this query is not working properly. i used sql developer translation scratch editor to convert that.
it's converted but i am not getting the exact value.
which i was getting in sql server.

here is my query below:

SELECT C.*,ISNULL(P.Comp_Name,'') + ' (' + ISNULL(P.Comp_ID,'') + ')' Parent FROM Comp_Master C LEFT JOIN Comp_Master P ON C.Parent_ID = P.Comp_ID Where C.Comp_ID='C02'

please convert it into oracle so that i can use this query

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2012

Added on Sep 13 2012

#11g, #general-database-discussions

2 comments

3,169 views