Data Manipulation Language(DML)
~10 mins
Prerequisite: Create Table
create table employees(id NUMBER,name VARCHAR2(20),city VARCHAR2(100));
select * from employees;
Task 1.1: Insert Records
insert into employees (id,name) values (1,'Naresh');
insert into employees (id,name ) values (2,'Prabhu'),(3,'Siva');
Task 1.2: Display Records
select * from employees;
Task 2.1: Update single column for all Rows
update employees set city='Chennai';
Task 2.2: Update multiple column for the given employee id
update employees set name='Naresh Kumar' , city='Chennai' where id =1 ;
Task 3: Delete a specific record
delete from employees where id = 1;
Task 4: Delete all rows
delete from employees;