Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display student records whose name starts with 'm' using like % operator

Posted By: Louie Brown     Category: Oracle     Views: 3585

Display student records whose name starts with 'm' using like %.

Code for Display student records whose name starts with 'm' using like % operator in Oracle

select * from student where name like'M%';

Output:

    ROLLNO NAME            CLASS      BIRTHDATE
---------- --------------  ---------- ---------

         1 Mikki Raval     A          20-MAR-84
         4 Mona Amin       B          08-APR-81
  
Share: 

 
 
 


Louie Brown
Louie Brown author of Display student records whose name starts with 'm' using like % operator is from London, United Kingdom.
 
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!