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

how to convert character strings to numeric values? : Sql dba

794


What are the ways on commenting in a pl/sql code?

707


What are the popular database management systems in the it industry?

752


What is the difference between a subquery and a join?

734


Can we call dml statement in function?

787


Why does sql need a server?

783


what is the difference between myisam static and myisam dynamic? : Sql dba

796


what is normalization? : Sql dba

760


Explian rowid, rownum?

768


What is the difference between the implicit and explicit cursors?

767


When can we use the where clause and the having clause?

793


What is constant in pl sql?

731


What are the different types of functions in sql?

786


What is the difference between rename and alias?

997


What is the difference between sql and isql*plus?

735