Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Data Manipulation LangRSS Feeds

Example to insert data using variables in a table

Posted By: James Evans     Category: Oracle     Views: 3118

This article provides an example to insert data using variables in a table.

Code for Example to insert data using variables in a table in Oracle

insertinto cust values (&custno,'&cname','&state',&phone);

insertinto item values (&itemno,'&itemname',&itemprice,&qty_hand);

insertinto invoice values (&INVNO,'&INVDATE', &CUSTNO);

insertinto invitem values (&INVNO, &ITEMNO,&QTY);
  
Share: 


Didn't find what you were looking for? Find more on Example to insert data using variables in a table Or get search suggestion and latest updates.

James Evans
James Evans author of Example to insert data using variables in a table 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!