Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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