Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example to find total value of each item based on current stock using multiplication operator in select query

Posted By: Isabel Hughes     Category: Oracle     Views: 3720

This article provides an example to find total value of each item based on current stock using multiplication operator in select query.

Code for Example to find total value of each item based on current stock using multiplication operator in select query in Oracle

select itemname, itemprice * qty_hand "Total valueofeach Item" from item;
  
Share: 



Isabel Hughes
Isabel Hughes author of Example to find total value of each item based on current stock using multiplication operator in select query 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!