DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=nU10r37GHT/D3YTa8LE9IuAkXvDY0GgTlC0omhgfm7imh34KpH4xayiniF4wbK68h7
	jVyk6NCLxIgwJ+GskhJQ98OLLfNvkqizWw7fKJHJOMaPCVZJi72bhPkRva/yUGx9IP9T
	ObCrk8IVCpZm/fdxb+S5ioSG6eFHyKcNk2xzc=
Message-ID: <4D0799F7.9050206@gmail.com>
Date: Tue, 14 Dec 2010 09:23:19 -0700
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20101027)
MIME-Version: 1.0
To: emaratiyya <emaratiyya@hotmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Using count on a join, group by required?
References: <AANLkTinYNWi1AQft188MBWj4n6OBfSQX1DdAO2Jf8wQu@mail.gmail.com>
	<1292311156150-3304147.post@n5.nabble.com>
In-Reply-To: <1292311156150-3304147.post@n5.nabble.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Shouldn't you be doing your own homework?

emaratiyya 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)
>
>