Answer Posted / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

How do sql databases work?

979

---

Explain the working of foreign key?

1043

---

Can we use ddl statements in stored procedure?

1129

---

How do you use join?

920

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2001

---

What is sql character function?

1049

---

What is the use of desc in sql?

956

---

What are the triggers associated with image items?

1030

---

Explain table and field in sql?

1048

---

what are set operators in sql? : Sql dba

1022

---

I need a function for a train ticket reservation please answer it thanks in advance

1001

---

Why indexing is needed?

973

---

What is raw datatype in sql?

1024

---

what are the nonstandard string types? : Sql dba

1119

---

How to create a menu in sqlplus or pl/sql?

1100

---