Results 1 to 7 of 7

Thread: Regarding views

  1. #1
    Junior Member
    Join Date
    Jul 2011
    Answers
    2

    Regarding views

    Hii

    I had created one view on table emp as v_emp to get only records of deptno=10

    and i dropped table emp.....

    and then executed view v_emp will it displys any records r not???


  2. #2

    Re: Regarding views

    no .......it will not display...........
    becoz view doesnt store any data.........


    thank u......


  3. #3
    Junior Member
    Join Date
    Apr 2008
    Answers
    1

    Re: Regarding views

    No, it will not display.


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

    Re: Regarding views

    View does not store and data, it only refers to physical data stores in some table.

    If you understand what a view is, you would never have asked this question.


  5. #5
    Junior Member
    Join Date
    Aug 2011
    Answers
    3

    Re: Regarding views

    Ya you are right but a view is a virtual table it doesn't hold any data but it gives the data of result set of the query it is possible in inline view


  6. #6
    Junior Member
    Join Date
    Feb 2012
    Answers
    6

    Re: Regarding views

    No.it wont Display.


  7. #7
    Junior Member
    Join Date
    Dec 2011
    Answers
    16

    Re: Regarding views

    Hi,
    As views are the logical objects it only stores query attached to it, It dosent occupies any space to store data. It jus fetch data based on the query and refelects. Now as base objects to which view was refering is elimineted, then no question of any data containing by view.


  8.  Sponsored Ads
    Ad


     

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