what is inline view?
Answers were Sorted based on User's Feedback
Answer / muhammad wali ullah
***An inline view is a subquery with an alias (or
correlation name) that you can use within a SQL statement.
***A named subquery in the FROM clause of the main query is
an example of an inline view.
***An inline view is not a schema object.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
You can find an example at:
http://forums.oracle.com/forums/thread.jspa?
messageID=1473644
Is This Answer Correct ? | 8 Yes | 9 No |
Answer / guest
You can find an example at <a
href="http://forums.oracle.com/forums/thread.jspa?
messageID=1473644">http://forums.oracle.com/forums/thread.js
pa?messageID=1473644</a>
Is This Answer Correct ? | 8 Yes | 10 No |
Answer / ravi kulkarni
A query which uses data as source is called inline view.
for example in select statement , query can be used to
represent table name .
Is This Answer Correct ? | 9 Yes | 20 No |
Answer / sreekanth
An inline view is a SELECT statement inside another SELECT
statement.
Is This Answer Correct ? | 8 Yes | 19 No |
What is a schema sql?
What is Collation Sensitivity ? What are the various type ?
What is trigger and how to use it in sql?
What are all types of user defined functions?
what are all the different types of indexes? : Sql dba
What are the PL/SQL Statements used in cursor processing ?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Explain ddl statements in pl/sql?
When is a declare statement required?
What are the operators used in select statements?
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
Is sql difficult?