what is inline view?

Answer Posted / 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.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the different types of indexes? : Sql dba

532


Why coalesce is used in sql?

473


What is auto increment in sql?

589


How to get unique records from a table?

525


Why plvtab is considered as the easiest way to access the pl/sql table?

621






Does group by remove duplicates?

553


How to move files from one directory to another in pl sql?

642


What is pl sql in oracle?

585


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

578


How does an execution block start and end in pl sql?

501


Can I learn sql in a week?

554


What is the difference between between and in condition operators?

538


Why do we create stored procedures & functions in pl/sql and how are they different?

504


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3207


Why functions are used in sql?

513