Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display items containing letter 't' in item name

Posted By: Harriet Hughes     Category: Oracle     Views: 2090

This article provides an example to display items containing letter 't' in item name.

Code for Display items containing letter 't' in item name in Oracle

select * from item where itemname like'%t%';

Output:

ITEMNO    ITEMNAME    ITEMPRICE    QTY_HAND    COLOR
------    ---------   ----------   ----------  ------

I0005     Monitor     700          125         Black
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Display items containing letter 't' in item name Or get search suggestion and latest updates.

Harriet Hughes
Harriet Hughes author of Display items containing letter 't' in item name is from London, United Kingdom.
 
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!