Snig2 - SQL> insert into branch23...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 SQL> insert into branch23 values('kandivali','mumbai',10000) 1 row created. SQL> insert into branch23 values('borivali','mumbai',20000) 1 row created. SQL> insert into branch23 values('malad','mumbai',30000) 1 row created. SQL> delete from branch23 3 rows deleted. SQL> delete SQL> delete from branch23 where assets >10000 0 rows deleted. SQL> update branch23 set assets=40000 0 rows updated. SQL> update branch23 set assets=50000 0 rows updated. SQL> update branch23 set assets=50000 where bcity='mumbai' 0 rows updated. SQL> select * from branch23 no rows selected SQL> insert into branch23 values('kandivali','mumbai',10000) 1 row created. SQL> insert into branch23 values('borivali','mumbai',20000) 1 row created. SQL> insert into branch23 values('malad','mumbai',30000) 1 row created. SQL> select * from branch23
Background image of page 1

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

View Full DocumentRight Arrow Icon
Sheet1 Page 2 BNAME BCITY ASSETS ------------------------------ ------------------------------ ---------- kandivali mumbai 10000 borivali mumbai 20000 malad mumbai 30000
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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 / 3

Snig2 - SQL> insert into branch23...

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

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