Results 1 to 5 of 5

Thread: Question

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Question

    Is it proper to create a view on a view? Or is it not good practice?

  2. #2
    Join Date
    Oct 2003
    Posts
    71

    Re: Question

    Originally posted by exdter
    Is it proper to create a view on a view? Or is it not good practice?
    It all depends on your requirement.
    There is nothing wrong about it.

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    I agree, nothing wrong with it, and many people have probably done it already without knowing it. For example, a query where the FROM clause is another query. That internal query is a special type of view called an inline view. If you created a view with this type of SQL, then your view contains a view, right?
    >select col list from (select col list from test where col1='hello');

    Look at the Oracle dictionary for more examples of views built on views built on views ... built on [table | C structure]. Now, that's nested!

    Mark
    9i OCP

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: Question

    HI,

    When there is a need we can create a view over another view. Even most of the data dictionary objects are view over other views.
    SATHISH .

  5. #5
    Join Date
    Aug 2003
    Posts
    328

    Re: Question

    Thanks everyone.

Posting Permissions

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