Thread: inline view how its work


Permlink Replies: 3 - Pages: 1 - Last Post: Sep 24, 2006 7:14 PM Last Post By: Eduardo Legatti
user518929

Posts: 103
Registered: 07/06/06
inline view how its work
Posted: Sep 24, 2006 9:36 AM
Click to report abuse...   Click to reply to this thread Reply
how it work can any body give me proper guide line about inline view
Justin Cave

Posts: 24,284
Registered: 10/11/99
Re: inline view how its work
Posted: Sep 24, 2006 9:51 AM   in response to: user518929 in response to: user518929
Click to report abuse...   Click to reply to this thread Reply
Can you clarify what, exactly, you're asking? That's potentially a rather large question.

Justin
Elyo Ravuna

Posts: 13
Registered: 09/24/06
Re: inline view how its work
Posted: Sep 24, 2006 10:15 AM   in response to: Justin Cave in response to: Justin Cave
Click to report abuse...   Click to reply to this thread Reply
If you are asking the definition of an "inline query", I can give you a simple example. Consider the following view:
    create or replace view MyView as
select 'test' as test from Dual
/
select MyView.*
from MyView
The following is the "inline view" version of the same query:
    select MyInlineView.*
from (select 'test' as test from Dual) MyInlineView
I hope it helps you...
Best regards.
Elyo Ravuna
Eduardo Legatti

Posts: 4,879
Registered: 11/27/01
Re: inline view how its work
Posted: Sep 24, 2006 10:51 AM   in response to: user518929 in response to: user518929
Click to report abuse...   Click to reply to this thread Reply
Hi,
As Elyo said, 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.
This site maybe help you:
http://www.akadia.com/services/ora_subquery_inlineview.html

Cheers
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums