Re: stored procedure

indianhuny wrote:
> Hi everyone,
> I'm new to this and I need some help with stored procedures. i'm
> using oracle 9i and would like to create a stored procedure to enter an
>
> order in the ORDER table and find out if this is the 10th order for the
>
> customer. The procedure receives all the information in the CUSTOMER,
> SERVICE and ORDER_ITEM tables. If the customer exists in the database,
>
> use the existing customer data and check if this is the 10th order for
> the customer, if yes give a 50% discount on that order. Otherwise,
> create a new row in CUSTOMER. Create the new ORDER and ORDER_ITEM
> rows.
>
> Thanx in advance for any help i can get on this.
>
>
> -K-

What help do you want? Are you interested in hiring a consultant to do you work for you or just for someone to provide general guidance?

Daniel Morgan
www.psoug.org Received on Mon May 01 2006 - 23:13:07 CEST