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 hadoop a nosql?

745


Which command is used to delete a package?

773


How do I find sql profiler?

683


what are the type of locks ? : Sql dba

720


What does cursor do in sql?

716






Can we use insert statement in function?

738


What is the difference between mdf and ndf files?

780


how to get @@error and @@rowcount at the same time? : Sql dba

741


What is clause in sql?

759


What is the use of function "module procedure" in pl/sql?

884


List different type of expressions with the example.

699


What found sql?

703


What is sql in java?

757


Which are sql * plus commands?

714


What are triggers and its uses?

790