Answer Posted / ashi

Sub query: The sub query has more than one select
statement,the inner query which executes first and then it
will be the value of the 2nd query.
EX:
select ename from emp where sal>(select avg(sal) from emp);

Joins:
When the data from more than one table in the database,then
a join condition used.Rows in the one table can be joined to
rows in the other table according ro the common values
existing in corresponding columns
EX:
select dname,ename from emp,dept where emp.deptid=dept.deptid;

if you ctreate table identity

2308

---

What is java oracle used for?

961

---

What are the database administrators utilities available?

970

---

What happens to indexes if you drop a table?

1107

---

How to select all columns of all rows from a table in oracle?

988

---

What are the numeric comparison operations?

1050

---

What is the parameter mode that can be passed to a procedure?

978

---

Explain an index?

1088

---

What is a database schema in oracle?

1052

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1321

---

How to assign values to data fields in record variables?

970

---

How to get execution path reports on query statements?

926

---

what is meant by magic query

2132

---

What are the original export and import utilities?

1052

---

What is an oracle user role?

936

---