Results 1 to 6 of 6

Thread: How many types of views are there?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    How many types of views are there?

    Hi Friends,

    Can you just tell me that How many types of views are there?


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: How many types of views are there?

    standard views, indexed views, and partitioned views

    dynamic views and snapshot views


  3. #3
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: How many types of views are there?

    Hi Barbie,

    I just have a small doubt reg the types of views which u have mentioned. Are they types of view of Oracle Database?
    As far as i know there are 2 types of views in Oracle, Simple View & Complex View.

    *** Innila ***

  4. #4
    Junior Member
    Join Date
    Apr 2007
    Answers
    11

    Re: How many types of views are there?

    hi all,

    there are two classification of views simple and complex.

    a simple one that.
    --derives data from one table
    --contains no function or group of data
    --can perform DML operation thru the view

    a complex one that.
    --derives data from many tables
    --contains functions or groups of data
    --does not always allows DML operation

    from
    samarendra mishra


  5. #5
    Junior Member
    Join Date
    Oct 2006
    Answers
    3

    Post Re: How many types of views are there?

    Quote Originally Posted by Subashini.Ramasamy View Post
    Hi Friends,

    Can you just tell me that How many types of views are there?
    As I know there are following three types of views
    1. simple views created by create or replace command
    2. inline views created while giving a select form table_name statement in from clause or column list or in where clause of a query
    3. materialized views used for data replication.


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: How many types of views are there?

    If u want the basic classification then u can go for

    1. Simple View
    based on a single table
    uses no functions or calcuations
    allows DML opeations
    2. Complex View
    based on multiple base table
    uses functions or calcuations or is readonly
    invilvs join.
    does not allows DML any opeations.
    3. Materialized View (Snapshot)

    this is mainly used for data replication

    In the first 2 types user have no control over data replication from the base table to the dependent view . This can be controlled by materialized view.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact