-
-
What are the commands that come in the category of DML in SQL?
DML refers to Data Manipulation Statements. That is used for accessing and modifying values or data present in the database. The commands that come in the category of DML in SQL INSERT SELECT DELETE UPDATE INSERT: This command is used to insert rows into the table. SYNTAX: INSERT INTO tablename VALUES (value,value,….); SELECT: This is used to select...
-
What is a view?
A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logical representation of one or more database tables. As we have seen above views have no data for themselves...