what is inline view?

Answer Posted / karthik

The inline view is a construct in Oracle SQL where you can
place a query in the SQL FROM, clause, just as if the query
was a table name.

A common use for in-line views in Oracle SQL is to simplify
complex queries by removing join operations and condensing
several separate queries into a single query.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of friend function? : Sql dba

535


how to analyze tables with 'mysqlcheck'? : Sql dba

540


What are the operators used in select statements?

568


What is the mutating table and constraining table?

552


Can dml statements be used in pl/sql?

570






How to select all records from the table?

601


What is sqlite used for?

524


what is bcp? When does it used? : Sql dba

516


Does db2 use sql?

508


How delete all records from table in sql?

548


What is the difference between a query and a report?

512


Is left join and outer join same?

541


What is sql profiling in oracle?

543


What is primary key and foreign key?

529


what is primary key? : Sql dba

508