From: | Trinath Somanchi <trinath(dot)somanchi(at)gmail(dot)com> |
---|---|
To: | emaratiyya <emaratiyya(at)hotmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Using count on a join, group by required? |
Date: | 2010-12-14 08:53:03 |
Message-ID: | AANLkTinY_7foFdLEAgStXXYdHT4qDo+mSqXqgxhWrrWk@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
what are the inputs to the PL-SQL procedure.
On Tue, Dec 14, 2010 at 12:49 PM, emaratiyya <emaratiyya(at)hotmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Regards,
----------------------------------------------
Trinath Somanchi,
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2010-12-14 16:23:19 | Re: Using count on a join, group by required? |
Previous Message | Filip Rembiałkowski | 2010-12-14 08:23:03 | Re: Aggregating by unique values |