Data Manipulation language commands:-
1.Insert: By using this command we can insert the data into the databse objects
Syntax: insert into student values (101, ‘Kalyan’, ‘12-jun-13’, ‘hyderabad’);
Syntax: insert into student values (&student_no,&student_name,&student_dob,&student_city);
Syntax: insert into student (student_no,student_name) values (&student_number, ‘&student_name’);
2.Update: By using this command we can modify the data which is present in the database object.
Syntax: update student set student_name= ’badri’ where student_id=23;
Syntax: update employee set bonus=1000;
//it will applicable to all employees in the db object.
Syntax: update employee set esal=esal+5000 where eid=23;
//it will applicable to only a particular employee whose eid is 23
3.Delete: By using this command we can delete the data from the existing database objects
Syntax: delete from student where student_name=’rajesh’;
//it will deletes the particular student details whose name is rajesh.
Note: The data which is present inside the database objects is case-sensitive.