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: 1993

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!