what is inline view?

Answer Posted / madhavi

An inline view is a subquery with an alias. It can be used
in the FROM clause of a SELECT statement. An inline view
defines a data source for the SELECT statement in which it
is defined. The columns specified in an inline view can be
accessed in the same way as the columns of a table or view.

Is This Answer Correct ?    38 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a full join sql?

814


What is insert command in sql?

813


What is t sql used for?

765


What is mutating error?

729


How can we solve sql error: ora-00904: invalid identifier?

920


What is a data definition language?

830


Does oracle use sql?

720


What is sql deadlock?

781


What is difference between table and view?

742


What does rownum mean in sql?

757


Does access use sql?

782


Explain normalization and what are the advantages of it?

718


How to look at the current sql*plus system settings?

796


explain access control lists. : Sql dba

750


What is the usage of nvl function?

801