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

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!