what is inline command?

Answers were Sorted based on User's Feedback



what is inline command?..

Answer / nagender k

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

Is This Answer Correct ?    6 Yes 1 No

what is inline command?..

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

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is sql data?

0 Answers  


What is record variable?

0 Answers  


What are tables and fields in the database?

0 Answers  


What is constant in pl sql?

0 Answers  


what is the difference between where clause and having clause? : Sql dba

0 Answers  






what is self join and what is the requirement of self join? : Sql dba

0 Answers  


List different type of expressions with the example.

0 Answers  


can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


How to return more than one value from a function?

11 Answers   Satyam,


how do you know the version of your mysql server? : Sql dba

0 Answers  


Which command is used to call a stored procedure?

0 Answers  


Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  


Categories