Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display customers which are from Gujarat city

Posted By: Jack Bouchard     Category: Oracle     Views: 1373

This article provides an example to display customers which are from Gujarat city.

Code for Display customers which are from Gujarat city in Oracle

select cname from cust wherestate='Gujarat';

Output:

CUSTNO    CNAME    STATE     PHONE       CITY   
-------   -------  --------  ----------  -------

C0098     Miki     Gujarat   9895900598  Bhopal
C0110     Kunj     Gujarat   9895980000  Ahmedabad
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display customers which are from Gujarat city Or get search suggestion and latest updates.

Jack Bouchard
Jack Bouchard author of Display customers which are from Gujarat city is from Montreal, Canada.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!