GeekInterview.com
Results 1 to 5 of 5

Types of views in Oracle

This is a discussion on Types of views in Oracle within the Databases forums, part of the category; Is there any types of views in Oracle? If so, please let me know......

  1. 01-07-2008 #1
    M_lakshmi
    M_lakshmi is offline Junior Member Array
    Join Date
    Aug 2007
    Answers
    2

    Types of views in Oracle

    Is there any types of views in Oracle? If so, please let me know...

    Reply With Quote Reply With Quote
  2. 01-07-2008 #2
    susarlasireesha
    susarlasireesha is offline Expert Member Array
    Join Date
    Apr 2007
    Answers
    542

    Re: Types of views in Oracle

    follow this useful link

    Reply With Quote Reply With Quote
  3. 01-10-2008 #3
    nareshbabu18
    nareshbabu18 is offline Junior Member Array
    Join Date
    Jan 2008
    Answers
    2

    Re: Types of views in Oracle

    what is the difference between cursor and collections

    Reply With Quote Reply With Quote
  4. 01-10-2008 #4
    susarlasireesha
    susarlasireesha is offline Expert Member Array
    Join Date
    Apr 2007
    Answers
    542

    Re: Types of views in Oracle

    Quote Originally Posted by nareshbabu18 View Post
    what is the difference between cursor and collections
    cursor
    When a query is executed in oracle, a result set is produced and stored in the memory. Oracle allows the programmer to access this result set in the memory through cursors.
    Collection
    A Collection is an ordered group of elements, all of the same type. Each element has a unique subscript, called an index, that determines its position in the collection

    Last edited by susarlasireesha; 01-10-2008 at 02:21 AM.
    Reply With Quote Reply With Quote
  5. 01-11-2008 #5
    Dhiraj_k
    Dhiraj_k is offline Junior Member Array
    Join Date
    Jan 2008
    Answers
    1

    Re: Types of views in Oracle

    Hello Laxmi,
    There r two types of VIEW in ORACLE.
    Simple View and Complex View
    simple view derives data from only one table but complex view derives data from many table
    simple view contain no functions or group of data but complex view contain function or group of data
    simple view always allow DML operation through th view but complex view does not always allow

    Reply With Quote Reply With Quote
    •    Sponsored Ads


« Triggers, debug and encryption | Relationship in Database »