I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

How do you know if sql server is running on your local system?

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

How to modify an existing user defined function?

0 Answers  

---

---

What is a trace frag? Where do we use it?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

Can two tables share a primary key?

0 Answers  

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---