Answer Posted / rahul baheti

Joins means we can join two or more then two table in
single query. and joins is combinatoin of two or more table.
there are Four type of join
1 Equi joins
2 Non Equi joins
3 Outer joins
4 Self joins

Difference between open_form and call_form in oracle.

670

---

Who developed oracle & when?

564

---

What is Virtual Private Database in Oracle?

609

---

How to assign data of the deleted row to variables?

577

---

Explain the use of indexes option in exp command.

588

---

---

How to convert times to characters in oracle?

599

---

How do I learn what codesets are available in oracle?

569

---

Can I create users through internet explorer in oracle 10g?

563

---

Whats the benefit of dbms_stats over analyze?

1487

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

851

---

How to create an oracle testing table?

584

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

561

---

How to execute a stored procedure in oracle?

614

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1174

---

What is an oracle cursor variable?

605

---