Answer / anil_abbireddy

A query is written at the from clause of an another query
is called inline view.

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

Answer / deva

The inline view is a named subquery where the inputs for
the query depends on the values provided by the outer
query. The values will be provided in every run of the
query.

Answer / inna

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.

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

Answer / roop

inline view is the named subquery in the FROM cause of the
main query.

Answer / alekhya

if we write a select query in from clause then it is called
as inlineview

Answer / neha

Writing a select statement in from clause is called an inline view.

Answer / suresh.pathuri

It is the select stataement in the from clause of the another select statement .it used simplyfy the complex queries and removing the many join operations on the table.
this type
select * from(select rownum from emp order by rownum desc) suresh where rownum<=5;

Answer / lakshmi

A named subquery in the from clause of main query is an example of inline view.
syntax:select * from (subquery)

Can we perform dml in function?

0 Answers  

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

What is a relationship and what are they?

0 Answers  

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

What are aggregate functions in sql?

0 Answers  

What is sql mysql pl sql oracle?

0 Answers  

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

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

1 Answers  

What is the clause we need to add in function body to return variable?

0 Answers  

Is like operator in sql case sensitive?

0 Answers