what is meant by magic query

0 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

How to install oracle database 10g xe?

0 Answers  

---

How to create a new table by selecting rows from another table?

0 Answers  

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,

---

Is insert autocommit in oracle?

0 Answers  

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

Please explain the difference between outer join and inner join? With examples would be appreciable..!

6 Answers   IBM,

---

What is SQL access advisor in Oracle?

0 Answers   MCN Solutions,

---