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 are the security recommendations while using mysql? : Sql dba

0 Answers  


What are sql ddl commands?

0 Answers  


Is like operator in sql case sensitive?

0 Answers  


how to check the 3rd max salary from an employee table?

23 Answers   IBM,


What is RAC in oracle?

7 Answers   MCN Solutions,






What is sql*loader and what is it used for? : aql loader

0 Answers  


What is full join?

0 Answers  


In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,


What is the clause we need to add in function body to return variable?

0 Answers  


PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  


How to write a query to show the details of a student from students table whose

0 Answers  


How long will it take to learn pl sql?

0 Answers  


Categories