Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display customers whose name starts with 's'

Posted By: Rainer Fischer     Category: Oracle     Views: 3829

This article provides an example to display customers whose name starts with 's'

Code for Display customers whose name starts with 's' in Oracle

select cname from cust where cname like'S%';

Output:

CUSTNO       CNAME       STATE         PHONE       CITY        
-------      --------    --------      ------      -----
C0002 Samay Maharashtra 9898989898 Mumbai C0003 Sonal MP 9895989598 Bhopal
  
Share: 


Didn't find what you were looking for? Find more on Display customers whose name starts with 's' Or get search suggestion and latest updates.

Rainer Fischer
Rainer Fischer author of Display customers whose name starts with 's' is from Frankfurt, Germany.
 
View All Articles

Related Articles and Code:


 
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!