Home » Developer & Programmer » Forms » how to reduce quantity (merged 2)
how to reduce quantity (merged 2) [message #572869] Tue, 18 December 2012 06:01 Go to next message
pakpolic@gmail.com
Messages: 23
Registered: June 2012
Location: Peshawar
Junior Member
how to reduce quantity from one table due to other table
for exple.
i have a purchase a shampo in 20 quantity
and then sale this shampo 2 quantity



so i want now there should be 18 quantity of shampo in purchase table automatically


Purchase table Sale tabel
Product Id Sale id
Product Name product name
Quantity Quantity
how to reduce quantity [message #572877 is a reply to message #572869] Tue, 18 December 2012 06:25 Go to previous messageGo to next message
pakpolic@gmail.com
Messages: 23
Registered: June 2012
Location: Peshawar
Junior Member
how to reduce quantity from one table due to other table
for exple.


so i want now there should be 18 quantity of shampo in purchase table automatically

Purchase table Sale tabel
Product Id Sale id
Product Name product name
Quantity Quantity
Re: i want to reduce quantity [message #572880 is a reply to message #572869] Tue, 18 December 2012 06:31 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
Write an update statement
Re: i want to reduce quantity [message #572978 is a reply to message #572880] Wed, 19 December 2012 02:30 Go to previous messageGo to next message
pakpolic@gmail.com
Messages: 23
Registered: June 2012
Location: Peshawar
Junior Member
how to write update statement
please with detail
Re: i want to reduce quantity [message #572981 is a reply to message #572978] Wed, 19 December 2012 03:00 Go to previous message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you really don't know how to write an update statement in oracle then I can only suggest you spend some time reading the documentation.

If you know how to write an update but aren't sure how to write the specific one you need then you need to give us more information about your tables. We can't write an update statement against tables we know nothing about.
Previous Topic: Oracle 10g - Need to stop the execution for specific query in running mode
Next Topic: best way to pass 100+ parameter in form A to form B
Goto Forum:
  


Current Time: Thu Dec 18 15:07:55 CST 2014

Total time taken to generate the page: 0.07403 seconds