Home » SQL & PL/SQL » SQL & PL/SQL » SQL
SQL [message #208199] Fri, 08 December 2006 09:53 Go to next message
prasad_ch
Messages: 1
Registered: December 2006
Location: HYDERABAD
Junior Member
what is inline view?
Re: SQL [message #208200 is a reply to message #208199] Fri, 08 December 2006 09:54 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Bold is the inline view:

select * from
(select * from dual)

Re: SQL [message #208203 is a reply to message #208199] Fri, 08 December 2006 10:03 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
> Inline view is not a view
> Inline views are independent SQL queries in the FROM clause of a SQL query.
e.g., select * from (select ename,dept from emp e,dept d
where e.deptno=d.deptno) iv;

in the above example (select ename,dept from emp e,dept d
where e.deptno=d.deptno)
is an inline view.

> As it acts as a view and appear in line with the query that is why it is called inline view.

Hope it helps...

Re: SQL [message #208224 is a reply to message #208199] Fri, 08 December 2006 12:28 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
prasad_ch wrote on Fri, 08 December 2006 10:53
what is inline view?

I guess you don't have google.com where you come from. Too bad, because it returned 44,000 answers. Maybe you can speak to the person in charge to unblock access to google.
Previous Topic: Search on first 3 characters of data
Next Topic: Job control via stored procedures
Goto Forum:
  


Current Time: Sat Dec 03 18:08:44 CST 2016

Total time taken to generate the page: 0.05177 seconds