1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

What is view and its benefits in Oracle SQL

Discussion in 'SQL PL/SQL' started by Puru, Oct 14, 2010.

  1. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Can any one of you tell me What is views and its benefits in Oracle SQL
     
  2. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    Re: Views

    Views are SQL queries with no physical data, but represent the physical table data in different orientation.
    No data is physically stored in database. Named SQL query is stored.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Since half of your question was answered I'll start with the second half of 'benefits of a view'.

    There may be many benefits to views such as:

    data security
    speed

    Of course just because one view may be fast another view may be quite slow in returning data so performance issues are listed among the negative aspects of views. Since views are nothing more than stored queries the best you can do to enhance their performance is by using hints or possibly stored outlines.

    There are many opinions on database views, so search google.com for more information and opinion.