From: Rob Sargent <robjsargent@gmail.com>
To: emaratiyya <emaratiyya@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using count on a join, group by required?
Date: Tue, 14 Dec 2010 09:23:19 -0700
Message-ID: <4D0799F7.9050206@gmail.com> (raw)
In-Reply-To: <1292311156150-3304147.post@n5.nabble.com>
References: <AANLkTinYNWi1AQft188MBWj4n6OBfSQX1DdAO2Jf8wQu@mail.gmail.com>
<1292311156150-3304147.post@n5.nabble.com>
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)
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, emaratiyya@hotmail.com
Subject: Re: Using count on a join, group by required?
In-Reply-To: <4D0799F7.9050206@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox