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-

indianhuny wrote:
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

indianhuny (kesha_mehta83 (AT) hotmail (DOT) com) 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

perhaps

create or replace package
create or replace package body

: to enter an
: order in the ORDER table

-- one way might be
SQLPLUS> exec my_pkg.enter_order('example','data');

: 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,

Sounds like typical programming logic. PL/SQL has numerous constructs
such as IF THEN ELSE that might help, and it integrates easily with SQL to
provide access to commands like SELECT (which can make use of the ever
useful EXISTS).

: if yes give a 50% discount on that order.

maybe somthing like

amount := amount * discount;


(etc etc etc)

thank u...this makes sense