deepak - ROLLNO D NAME---------- - --------------------2 A...

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

View Full Document Right Arrow Icon
DEEPAK AGRAWAL SE CMPN A ROLL NO 3 PRAC2 SQL> create table student 2 ( rollno integer, 3 div varchar(1), 4 name varchar(20) 5 ); Table created. SQL> select * from student; no rows selected SQL> insert into student values(2,'A','Rishi Agarwal'); 1 row created. SQL> insert into student values(3,'A','Deepak Agrawal'); 1 row created. SQL> insert into student values(8,'A','Sharad Bhat'); 1 row created. SQL> SELECT *FROM STUDENT;
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ROLLNO D NAME---------- - --------------------2 A Rishi Agarwal 3 A Deepak Agrawal 8 A Sharad Bhat SQL> update student set div='b' where rollno=3; 1 row updated. SQL> select *from student; ROLLNO D NAME---------- - --------------------2 A Rishi Agarwal 3 b Deepak Agrawal 8 A Sharad Bhat SQL> delete from student; 3 rows deleted. SQL> select *from student; no rows selected...
View Full Document

Ask a homework question - tutors are online