Solved

need MSSQL to oracle translator

Posted on 2011-03-10
2
324 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:cschene
2 Comments
 
LVL 142

Accepted Solution

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

Author Closing Comment

by:cschene
Comment Utility
fast---got the solution in a few minutes
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now