DML COMMANDS Program in RDBMS - SVRR TECH

Aim:

To explore the simple queries with DML commands using SQL.

Algorithm:

Step 1: Start the program.

Step 2: Create the Table.

Step 3: Insert query used to insert the values.

Step 4: Update the command used to change the values in existing table.

Step 5: Delete command is used to delete the records from table.

Step 6: Select used to view the table values.

Step 7: Get the output.

Step 8: Stop the program.

Program

create table emp01(emp_name varchar(20),emp_no varchar(15),emp_salary number(15));

insert into emp01 values('sethu', 'm6001', 20000);

insert into emp01 values('hari', 'm6002', 30000);

insert into emp01 values('krishna', 'm6003', 40000);

select * from emp01;

update emp01 set emp_salary=50000 where emp_name='Hari';

select * from emp01;

delete from emp01 where emp_salary<25000;

select * from emp01;