Re: Inline Views

An inline view is when you create a new view "on the fly" as part of the FROM clause of an SQL statement. Note that to access the columns of the inline view, you HAVE to use an alias. It goes like this:

select my_column_from_B, A.my_column_from_A from B,
(select my_column_from_A from my_inline_table where whatever_conditions) A;

The other alternative to inline views is to define a new view in the database, and access this new view in the FROM clause of your SQL statement. This is probably the preferred method if you intend to use this inline view often. But you need the CREATE VIEW privilege to do this. You don't need any privilege (besides the SELECT right to the underlying table) to use an inline view.

A dynamic view usually refers to the data dictionary tables. They are the V$... tables.

Daniel

hari_bk_at_yahoo.com (Harikishan) wrote in message news:<59570e8b.0212232317.4acdb567_at_posting.google.com>...
> what is inline view or Dynamic views? How they are diffrent from
> ordinary views? How they work?
Received on Fri Dec 27 2002 - 17:07:20 CET