oracle vie and sql query

C# Corner

Sushant Torankar

1y477SQL Server

hello,

i have created one VIEW in ORACLE. i want to use that ORACLE VIEW in SQL QUERY with JOINS using linked server.

Any help would be appericiated !!

Thank You !

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi1y ago

You can use OPENQUERY, and make sure you view is accessible by the linked server login :

SELECT 
    e.EmployeeID,
    e.FirstName,
    e.LastName,
    ov.DepartmentName,
    ov.Location
FROM 
    dbo.Employees e
LEFT JOIN 
    OPENQUERY(ORACLE_LINKED, 'SELECT EmployeeID, DepartmentName, Location FROM MY_ORACLE_VIEW') ov
    ON e.EmployeeID = ov.EmployeeID;