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

how to extract a unit value from a date and time? : Sql dba

762


How to get each name only once from an employee table?

824


Can one improve the performance of sql*loader? : aql loader

793


What is insert command in sql?

805


How do temporal tables work?

711


What is the use of sql trace?

714


How do I find duplicates in a single column in sql?

764


Does mysql_real_escape_string prevent sql injection?

711


How many sql core licenses do I need?

703


Can we insert delete data in view?

750


Write the command to remove all players named sachin from the players table.

937


What is nvl?

810


define sql delete statement ? : Sql dba

768


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

788


Mention what does the hierarchical profiler does?

760