Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    11

    Unanswered: View in Database

    How to create view of the table in a database?

    I am confused. People say that it is alias of the table with the same data content but a renamed table of the same.

    Please explain to me.

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When all else fails, RTFM

    http://download-west.oracle.com/docs...chem.htm#24841

    Views

    A view is a tailored presentation of the data contained in one or more tables or other views. A view takes the output of a query and treats it as a table. Therefore, a view can be thought of as a stored query or a virtual table. You can use views in most places where a table can be used.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2004
    Posts
    11
    Thanks.

    Perfect and clear answer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •