Delete Query:
delete from customer where cus_no=005;


Select Query:
select * from customer ;

Output:

CUS_NO  CUS_NAME  ADDRESS  CITY  STATE  PINCODE   BAL_DUE
------ ---------- -------- ----- ------ -------- ----------
001   pratik  reti mohalla  rajsamand   rajsathan  313324  10000
002    aman   jk mohalla    rajsamand   rajsathan  321324  15000
003  dilkhush    dil       pratapgard   rajsathan  312324  10000
004    Ajay    x mohalla      chennai   tamilnadu  123224  20000
006   nimai  new mohalla   bangalore    karnatak   123224  20000
007  jayesh     k road     bangalore    karnatak   233224  30000
008  sayam      my city    bangalore    karnatak   233224  30000


Leave a Reply

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

All Notes  on BCA
BCA all subjects notes

Total Pageviews

Translate

Powered by Blogger.

Copyright © All Notes on BCA