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

How do you update a sql procedure?

0 Answers  

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

What is multiple partition?

0 Answers  

---

what are the nonstandard string types? : Sql dba

0 Answers  

---

---

Does sql*plus have a pl/sql engine?

0 Answers  

---

what is a tablespace? : Sql dba

0 Answers  

---

How to order siblings in oracle hierarchy queries?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

Is it possible to sort a column using a column alias?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

how to create a database in oracle?please gve anser with example

1 Answers  

---