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 |
Which join is like an inner join?
What is primary and foreign key?
What are the new features in Oracle 10g. Compared to Oracle 9i?
what eliminate duplicate without using roenum and not
How much does sql certification cost?
What is the relation b/w view and trigger
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
when is the use of update_statistics command? : Sql dba
How do I run a pl sql procedure in sql developer?
How do I pipe the output of one isql to another?
Write a unique difference between a function and a stored procedure.
What is the function that is used to transfer a pl/sql table log to a database table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)