basically I have 2 tables and I'm trying to calculate the total sales for it.

products
pid
pname
price
Q_on_hand


Orders
Oid
Quantity

I'm trying to figure out how to write a sql state that show total sales by products:Pid and Pname. Then totalsales.

hopefull someone can help me out with this or point me out to the right direction as I don't know how to do the calculation part in oracle at all.