Solved

need MSSQL to oracle translator

Posted on 2011-03-10
2
327 Views
Last Modified: 2012-05-11
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
Comment
Question by:Christopher Schene
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35100534
use <> -1 instead of != -1 , would work in both ms sql server and oracle.
0
 

Author Closing Comment

by:Christopher Schene
ID: 35101035
fast---got the solution in a few minutes
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question