what is inline command?

Answer Posted / 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

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql a case sensitive language?

527


What is the difference between sql, mysql and sql server?

539


What is a composite primary key?

596


What is the purpose of my sql?

519


What is a clob in sql?

575






what's the difference between a primary key and a unique key? : Sql dba

520


what is collation? : Sql dba

626


How many joins in sql?

568


What is sql rowcount?

568


How many databases can sql express handle?

542


Inline the values in PL/SQL, what does it mean.?

643


In what condition is it good to disable a trigger?

566


What is full join?

539


What is the difference between function, procedure and package in pl/sql?

570


What is the maximum rows in csv?

499