This winter holiday season, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=17]

10 thoughts on “Database : Basics of Database Discussion 8

  • karim

    View is a Logical subset of data from one or more tables. It used to restrict data access.

  • Pamela halbhavi

    A database view is the set of column and rows of data from one or more tables presented to a user as if it were all of the rows and columns in a single table. Views are sometimes called virtual tables and can execute most of the sql queries on them. A view is actually a query and output of a query becomes the content of the view.

  • Pamela halbhavi

    Views can hide complexity .
    Views are used to enforce security.

  • Essa

    View is a virtual table which contains rows and columns just like a real table.It shows all up to date data.

  • nabeel

    View is a virtual table. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. Here is the formula to create it.
    CREATE VIEW view_name AS
    SELECT column_name(s)
    FROM table_name
    WHERE condition

  • nasir

    View in database systems is a virtual table based on the result-set of an DQL statement. Again simply the representation of a SQL statement that is stored in memory so that it can easily be re-used. A view contains rows and columns just like a real table. We can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
    You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

  • collins

    view is a virtual table that contains rows and columns that cannot be deleted

  • Olubunmi Ogunsola

    a view is a virtual table that contains rows and columns and allows you to execute certain commands on SQL.
    – Tomiwa

  • bruno

    A view in database systems is the representation of a SQL statement that is stored in memory so that it can easily be re-used. For example;
    – SELECT customername FROM customer WHERE countryid= “US”

  • sivi ramesh

    view is the virtual table based on result of SQL statements.
    By creating View, It allow us to reuse common ways of looking at the data without having to write the same complex SQL over and over .

    It is also used to tighten security on the source tables for the particular user while allowing them to see the data through the views.

Leave a Reply