• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

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
0
Christopher Schene
Asked:
Christopher Schene
1 Solution
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now