exp2 - 1 RISHI 1000 2 AGARWAL 500 3 DRAGON 4500...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Aim : To study simple DML commands is SQL RISHI AGARWAL ROLL NO 02 SE CMPN A SQL> create table rishi(Sr_no int,C_Name varchar(30),Amt int); Table created. SQL> insert into rishi values(001,'RISHI',1000); 1 row created. SQL> insert into rishi values(002,'AGARWAL',500); 1 row created. SQL> insert into rishi values(003,'DRAGON',4500); 1 row created. SQL> select *from rishi; SR_NO C_NAME AMT ---------- ------------------------------ ----------
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 RISHI 1000 2 AGARWAL 500 3 DRAGON 4500 SQL> update rishi set Amt=5000 where Sr_no=2; 1 row updated. SQL> select *from rishi; SR_NO C_NAME AMT---------- ------------------------------ ----------1 RISHI 1000 2 AGARWAL 5000 3 DRAGON 4500 SQL> delete from rishi where Sr_no=3; 1 row deleted. SQL> select *from rishi; SR_NO C_NAME AMT---------- ------------------------------ ----------1 RISHI 1000 2 AGARWAL 5000...
View Full Document

Ask a homework question - tutors are online