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

What is the source code of a program?

0 Answers  

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

What is 19 null in sql?

0 Answers  

---

What are user defined functions?

0 Answers  

---

How do I clear the screen in sql plus?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

What is Difference Between delete and Truncate?

9 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

Why do we need cursor in pl sql?

0 Answers  

---