Select Specific Rows Oracle Database Tutorial Example

How To Select Specific Rows From Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to select specific rows 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 TestName, TestAge FROM  test WHERE TestAge=30;

      -- that's it!! TestName, TestAge columns of TestAge=30 of Oracle database table "test" has been selected
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Select Specific Rows From Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

1. How To Select Specific Columns From Oracle Database Tutorial Example
2. How To Select Data Using Like From Oracle Database Tutorial Example
3. How To Use ROWNUM In Oracle Database Tutorial Example
4. How To Use IS NULL In Oracle Database Tutorial Example
5. How To Use IS NOT NULL In Oracle Database Tutorial Example
6. How To Ascending Sort/Order Data In Oracle Database Tutorial Example
7. MySQL NULL to Zero Value Example
8. MySQL IFNULL() Function Example Using PHP
9. How to Drop Column From MySQL Existing Table Example
10. 19 Examples to Learn MySQL
11. UNIX Command Example: grep - Searching word or string in file or content
12. UNIX Command Example: cat - Read file(s)