need MSSQL to oracle translator

Hi,

I would like to translate the MS SQL statement so it can used for Oracle 9G:

MYLICENSE where MYLICENSE.CLIENT_KEY not in (select MYDESKTOP.DESkTOP_NAME from MYDESKTOP) and MYLICENSE.MYLICENSE_ID != -1

Thanks.

Chris Schene
Christopher ScheneSystem Engineer/Software EngineerAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
use <> -1 instead of != -1 , would work in both ms sql server and oracle.
0
 
Christopher ScheneSystem Engineer/Software EngineerAuthor Commented:
fast---got the solution in a few minutes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.