How To Select Specific Columns From Oracle Database Tutorial Example
Run MS-DOS command prompt then copy & paste the below code to select specific columns data 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;
-- that's it!! TestName, TestAge columns of all rows of Oracle database table "test" have been selected -- is comment in Oracle -- in fact it is comment in MSSQL and MySQL as well
How To Select Specific Columns From Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools
Related Tutorial Examples
- How To Descending Sort/Order Data IN Oracle Database Tutorial Example
- How To Select Data Using Like From Oracle Database Tutorial Example
- How To Use ROWNUM In Oracle Database Tutorial Example
- How To Use IS NULL In Oracle Database Tutorial Example
- How To Use IS NOT NULL In Oracle Database Tutorial Example
- MySQL IF() Function String Value Example
- How to Find MySQL Stored Procedure or Function Information
- 19 Examples to Learn MySQL
- 20 Steps to Learn CakePHP by Example
- UNIX Command Example: kill - Kill Stops a Process
No comments:
Post a Comment
leave your comments here..