I want to write procedure that has three fields
1. Unique key
2. Name
3. Method of payment
The Method of payment can have multiple entries, for example if the
customer pays by cash and his or her info is inserted, but later he
decides to change the Method of payment and pay by Credit Card. So the
same record can have multiple entries
I’m thinking to create two tables, if the customer decides to pay by
different method. I move the first info inserted, say cash into another
table and keep only the new method of payment which is for the above
example Credit Card

Any help on how to write the stored procedure
Thanks



Yoseph Ibraham Fahed
Senior DBA and System Analysis
MCDBA,MCP
OCP
965 665-6210



Oracle LazyDBA home page