Insert Specific Columns Oracle Tutorial Example

How To Insert Specific Columns In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to insert specific columns into a table in Oracle Database Server Tutorial Example

-- connect as TUTORIAL
-- i am using sqlplus as client. you can use anything as you like.
 
   INSERT INTO  test(TestName,TestAge) VALUES ('CFSuman', 35);
      -- that's it!! a row with specific columns has been inserted in Oracle database table "test"
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Insert Specific Columns In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Select Data From Oracle Database Table Tutorial Example
  2. How To Select Specific Rows From Oracle Database Tutorial Example
  3. How To Select Specific Columns From Oracle Database Tutorial Example
  4. How To Select Data Using Like From Oracle Database Tutorial Example
  5. How To Use ROWNUM In Oracle Database Tutorial Example
  6. MySQL IF() Function NULL Value Example
  7. MSSQL PRINT Like Function in MySQL Example
  8. Parentheses in SQL Command MySQL Example
  9. 19 Examples to Learn MySQL
  10. 20 Steps to Learn CakePHP by Example

No comments:

Post a Comment

leave your comments here..