Answer Posted / t.murali krishna

Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join

What is oracle database client?

544

---

What is difference between cartesian join and cross join?

582

---

How to view the data files in the current database?

584

---

How to execute the package in oracle?

562

---

How to add a new column to an existing table in oracle?

576

---

---

What is recovery manager in Oracle?

583

---

How to start an oracle instance?

568

---

What is a tns service name?

528

---

How to connect the oracle server as sysdba?

623

---

How to export data to a csv file?

614

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1522

---

What is data block in Oracle?

613

---

what happened to the global index when I truncate the data in one of the partition?

1513

---

Explain the types of exception?

643

---

How do you bind variables in oracle?

540

---