Answer Posted / deepika s verma

In Oracle we can catogrise joins in following ways -
(1) Equi Join (Query having joining condition)
- Natural Join
- Join Using
- Join ON
(2) Non Equi Join or Cartesian Join ( without using joining
condition)
(3)Outer Join
- left outer join
- right outer join
- full outer join
(4) self Join or Theta Join
(5) Cross Join
(6) Inner Join

How to import one table back from a dump file?

1025

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1883

---

What is the difference between count (*), count (expression), count (distinct expression)?

1005

---

How to create a stored procedure in oracle?

1103

---

What is set verify off in oracle?

1103

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

How to create id with auto_increment on oracle?

990

---

What are named parameters?

1090

---

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?

2008

---

What are the system predefined user roles?

1042

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2369

---

What is object data modeling?

966

---

How to pass a parameter to a cursor in oracle?

1179

---

How to convert dates to characters in oracle?

1041

---

How to convert numbers to characters in oracle?

1030

---