11
Reply

Do view contain Data?

Sapna Malik

Sapna Malik

Jun 06, 2011
6.3k
0

    view is a mirror of database ,it does not contains a data..

    patel keyur
    December 18, 2014
    2

    yes like mirror, you see it mirror, u got result

    RajaGopal Gce
    January 21, 2017
    1

    If normal view than it does not contains the data. and if it is materialized view than it contains the data.

    Ashish Srivastava
    July 08, 2016
    0

    If normal view than it does not contains the data. and if it is materialsed view than it contains the data.

    Keerthi Venkatesan
    April 20, 2016
    0

    View does not conatains data it fetch the data from the underlying tables.

    RAHUL SHUKLA
    July 29, 2015
    0

    No, view do mot contain data. it contains only the SQL Statement.When we try to fetch the data from view , it internally hits the table and get the data from the table.

    no

    Debendra Dash
    April 21, 2015
    0

    yes views(SQl) can be consider as virtual table containing data.

    trilochan
    October 14, 2014
    0

    No, Views do not have any data for own , it derives data from n number of tables to reduce user Query process, Increase Security..

    Views, generally do not contain data of their own. They are basically SQL Commands stored and they return the resultant data based upon the SQL statement, used as the View definition.

    However, in Oracle, you have a concept of Materialised Views, which actually hold data, based upon the SQL command associated with the same view.

    Ashish Doshi
    June 08, 2011
    0

    The views do not contain data and store data.

    Sapna Malik
    June 06, 2011
    0