Answer / siddiq

In oracle joins, there is no need to mention the words like
left outer join, right outer join, etc..
Oracle joins sql joins
-------------------------------------------------
self join Natural join
cross join Arbitary join
outer join Left outer join
Equi join Right outer join
Non Equi join Full outer join

In sql server we have to use the words(join) in the query.

Answer / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Answer / veereshkethari

I'm not happy with Uma answer,anybody can explain?please

What is the use of %rowtype?

0 Answers  

---

What do we need to check in database testing?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

Can a key be both primary and foreign?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What is difference between joins and union?

0 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---

How does stored procedure reduce network traffic?

0 Answers  

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

What is hibernate and its relation to sql?

0 Answers  

---