Select Query:
Output:
select * from customer where city ='chennai';
Output:
CUS_NO CUS_NAME ADDRESS CITY STATE PINCODE BAL_DUE ------ --------- -------- ----- ------ ------- -------- 004 Ajay x mohalla chennai tamilnadu 123224 20000 005 shiva xyz mohalla chennai tamilnadu 21124 30000
