Results 1 to 2 of 2

Thread: Inline View

  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Inline View

    Hi All,

    I would like to know about INLINE VIEW ( with examples )
    and how this one is different from normal view ?


    Thanks

    JD

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    An Inline view is a sub query in the form clause of an outer subquery.
    The subuqery must have an alias to be classified as an inline view.
    An inline view is not a data structure that stores any data. Oracle does not stores inline view information in oracle datadictionary.Oracle stores
    normal views information in data dictionary.
    For example
    Normal view
    Create view test as
    SELECT 3*AVG(salary) avg_sal_x_3
    FROM employees

    select e.empno,e.sal from employees e,test a
    WHERE e.sal > a.avg_sal_x_3;

    inline view
    select e.empno,e.sal from employees e,(SELECT 3*AVG(salary) avg_sal_x_3 FROM employees) a
    WHERE e.sal > a.avg_sal_x_3;


    Thanks,
    Pagnint
    (No need to search web before posting new question)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •