what are the inputs to the PL-SQL procedure. On Tue, Dec 14, 2010 at 12:49 PM, emaratiyya <emarati...@hotmail.com> wrote:
> > Hi,Please help me solving this problem. I appreciate..Thankyou. > > Create the following table and insert few arbitrary records. > Product (product_id, product_name, supplier_name, quantity, price_per_unit) > You are required to create PL/SQL package that achieves the following > functionalities: > > • Obtaining the product supplier name by using the product_id > • Changing the price_per_unit by using the product_id > • When changing the price of the product, you have to have PL/SQL > code that > keeps the history of the prices. For this functionality you need to create > audit table: product_audit(product_id, old_price, new_price, > date_of_change) > • Updating the quantity by using the product_id > • Get warning when the product level of stock (quantity) goes below > certain > threshold (e.g. 10) > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Using-count-on-a-join-group-by-required-tp2471469p3304147.html > Sent from the PostgreSQL - sql mailing list archive at Nabble.com. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Regards, ---------------------------------------------- Trinath Somanchi,
