what is inline command?
Answers were Sorted based on User's Feedback
Answer / nagender k
Inline view is a subquery in the from clause of your main
query.
Is This Answer Correct ? | 6 Yes | 1 No |
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 |
What is sql data?
What is record variable?
What are tables and fields in the database?
What is constant in pl sql?
what is the difference between where clause and having clause? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
List different type of expressions with the example.
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
How to return more than one value from a function?
how do you know the version of your mysql server? : Sql dba
Which command is used to call a stored procedure?
Mention what problem one might face while writing log information to a data-base table in pl/sql?