Simple pass thru query to Oracle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » Simple pass thru query to Oracle

Simple pass thru query to Oracle

Rate Topic

Display Mode

Topic Options

Author

Message

Phunhog

Posted Monday, August 20, 2012 7:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 12:34 PM
Points: 36, Visits: 203

Hello Oracle Forum:

I've got my first linked server established from SQL Server 2008 SSMS to Oracle.
What is the proper syntax for this simple query with a date expression in the where clause?
What is the proper date delimiter?
Is there a conversion necessary?

SELECT TOP (5) SURGERY_DATE
FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = ('8/1/2012')' AS a

Many thanks ahead of time.

Phunhog

Post #1347176

PaulB-TheOneAndOnly

Posted Monday, August 20, 2012 3:50 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,982, Visits: 4,399

Cross post, please answer here: http://www.sqlservercentral.com/Forums/Topic1347483-1044-1.aspx

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Post #1347499

« Prev Topic | Next Topic »

Permissions