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.

Answer / guest

You can find an example at:
http://forums.oracle.com/forums/thread.jspa?
messageID=1473644

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>

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 .

Answer / sreekanth

An inline view is a SELECT statement inside another SELECT
statement.

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

Why are aggregate functions called so?

0 Answers  

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

What is magic table?

6 Answers  

Explain the components of sql?

0 Answers  

What is a string data type in sql?

0 Answers  

Is clustered index a primary key?

0 Answers  

what is the difference between undefined value and null value? : Sql dba

0 Answers  

what is Complex index. how to create it?

2 Answers  

How do you take the union of two tables in sql?

0 Answers  

What is foreign key and example?

0 Answers  

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers