pracs2_dml_commands

Pracs2_dml_commands - 521 4 Rishi B 527 37 Shweta 553 SQL> select name from rishib NAME-Aabhas A Rishi A Deepak A Rishi B Sheet1 Page 2 Shweta

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 12 14:51:43 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> create table rishib(roll_no integer,name varchar(25),marks integer) Table created. SQL> insert into rishib values(1,'Aabhas A',524) 1 row created. SQL> insert into rishib values(2,'Rishi A',480) 1 row created. SQL> insert into rishib values(3,'Deepak A',521) 1 row created. SQL> insert into rishib values(4,'Rishi B',527) 1 row created. SQL> insert into rishib values(37,'Shweta',553) 1 row created. SQL> select * from rishib ROLL_NO NAME MARKS ---------- ------------------------- ---------- 1 Aabhas A 524 2 Rishi A 480 3 Deepak A
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 521 4 Rishi B 527 37 Shweta 553 SQL> select name from rishib NAME-------------------------Aabhas A Rishi A Deepak A Rishi B Sheet1 Page 2 Shweta SQL> select roll_no,name from rishib where marks>525 ROLL_NO NAME---------- -------------------------4 Rishi B 37 Shweta SQL> update rishib set name='RISHI BALDAWA' where marks=527 1 row updated. SQL> select * from rishib ROLL_NO NAME MARKS---------- ------------------------- ----------1 Aabhas A 524 2 Rishi A 480 3 Deepak A 521 4 RISHI BALDAWA 527 37 Shweta 553 SQL> delete from rishib where marks<523 2 rows deleted. SQL> select * from rishib ROLL_NO NAME MARKS---------- ------------------------- ----------1 Aabhas A 524 4 RISHI BALDAWA 527 37 Shweta 553 SQL> delete from rishib 3 rows deleted. SQL> select * from rishib no rows selected SQL>...
View Full Document

This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.

Page1 / 2

Pracs2_dml_commands - 521 4 Rishi B 527 37 Shweta 553 SQL> select name from rishib NAME-Aabhas A Rishi A Deepak A Rishi B Sheet1 Page 2 Shweta

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online