Answer / nagender k

Inline view is a subquery in the from clause of your main
query.

Answer / rajeshwaran

An inline command is nothing but and Inline view that act
as a data-source for an Query.
Another important info about the Inline command is that it
is not an Schema Object.

example : (select rownum,e.eno
from (select eno from emp) e
where rownum <=3)

The query will result the TOP_3_analysis .In which the query
(select eno from emp) is known as INLINE_view or
INLINE_Query

Why use subqueries instead of joins?

0 Answers  

---

Is subquery faster than join?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

How to call shell script from pl sql procedure?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

What does the hierarchical profiler does?

0 Answers  

---

What is a unique constraint?

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

What is meant by truncate in sql?

0 Answers  

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---