Select Using Like Oracle Database Tutorial Example

How To Select Data Using Like From Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to select data using LIKE from a table in Oracle Database Server Tutorial Example

-- CONNECT as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 

   SELECT * FROM test WHERE TestName LIKE '%Su%';

   -- that's it!! all rows and all columns of Oracle database table "test"
   -- whose Name has the string "Su" have been selected
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Select Data Using Like From Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

1. How To Descending Sort/Order Data IN Oracle Database Tutorial Example
2. How To Use ROWNUM In Oracle Database Tutorial Example
3. How To Use IS NULL In Oracle Database Tutorial Example
4. How To Use IS NOT NULL In Oracle Database Tutorial Example
5. How To Ascending Sort/Order Data In Oracle Database Tutorial Example
6. MySQL IF() Function Number Value Example
7. How To Find MySQL SERVER VERSION Information
8. Operator precedence in SQL Command MySQL Example
9. 19 Examples to Learn MySQL
10. 20 Steps to Learn CakePHP by Example
11. UNIX Command Example: ps - Display Process List Information