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

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!