Practicing DML Commands

AIM: Applying DML commands.

Data Manipulation Command:

Data Manipulation commands are most widely used SQL commands and they are
Insert
Update
Delete 
Select

a) Insert command: 

After creation of table, it is necessary it should have data in it. The insert command is used to add data in form of one or more rows to a table as per follows:
Insert into values (a list of data values);

In a list of data values you have to specify values for each and every column in the same order as they are defined. A value of each column is separated by comma in the list. 
The value of char, nchar, and varchar2, nvarchar2, raw, long and date data types are enclosed in single quotes.


b)UPDATE Table:


C)DELETE:




d)SELECT:

Previously we have seen simple use of select statement to retrieve the data from the table. Now we have look further use of Select statement.