Re: Using count on a join, group by required?

what are the inputs to the PL-SQL procedure.<br /><br /><div class="gmail_quote">On Tue, Dec 14, 2010 at 12:49 PM,
emaratiyya<span dir="ltr"><<a href="mailto:emaratiyya@hotmail.com">emaratiyya@hotmail.com</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;"><br /> Hi,Please help me solving this problem. I appreciate..Thankyou.<br /><br /> Create the
followingtable and insert few arbitrary records.<br /> Product (product_id, product_name, supplier_name, quantity,
price_per_unit)<br/> You are required to create PL/SQL package that achieves the following<br /> functionalities:<br
/><br/> •       Obtaining the product supplier name by using the product_id<br /> •       Changing the price_per_unit
byusing the product_id<br /> •       When changing the price of the product, you have to have PL/SQL code that<br />
keepsthe history of the prices. For this functionality you need to create<br /> audit table: product_audit(product_id,
old_price,new_price, date_of_change)<br /> •       Updating the quantity by using the product_id<br /> •       Get
warningwhen the product level of stock (quantity) goes below certain<br /> threshold (e.g. 10)<br /><br /> --<br />
Viewthis message in context: <a
href="http://postgresql.1045698.n5.nabble.com/Using-count-on-a-join-group-by-required-tp2471469p3304147.html"
target="_blank">http://postgresql.1045698.n5.nabble.com/Using-count-on-a-join-group-by-required-tp2471469p3304147.html</a><br
/>Sent from the PostgreSQL - sql mailing list archive at Nabble.com.<br /><font color="#888888"><br /> --<br /> Sent
viapgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br /><br clear="all"
/><br/>-- <br />Regards,<br />----------------------------------------------<br />Trinath Somanchi,<br />