Answer / suresh kumar somayajula

SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".

In this ..Inner query will execute first.based on that
result outer query will execute.

Thank you,
Suresh

Answer / anil_abbireddy

Runs first,executed once,returns values to be used by the
MAIN Query

Answer / ramesh

A sub query is a query and it is deepened main query on the another query is called as a sub-query.

Answer / rashmi

Query inside a query is called sub query. Always to execute successfully the outer query depends on the output of inner query.
it is if 4 types.

>Scalar sub query
>Corelated sub query
>Nested sub query
>Inline view

what is an index? : Sql dba

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

How to prepare for oracle pl sql certification?

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

What is 19 null in sql?

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Does oracle use sql?

0 Answers  

---

How does an execution block start and end in pl sql?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How to read xml file in oracle pl sql?

0 Answers  

---