soonshengy
asked on
Writing a SQL Plus Stored Procedure
I'm new to stored procedures and I'm supposed to write one which will create an invoice once a booking is made and calculate the total amount for the invoice. The only procedure I need to pass to the procedure is the number of the booking for which I need to create the invoice. A sequence should be used to generate the invoice number.
The attributes in the INVOICE table are: invoice_no, invoice_date, total_amount, due_date and amount_paid.
Could anybody help please?
The attributes in the INVOICE table are: invoice_no, invoice_date, total_amount, due_date and amount_paid.
Could anybody help please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is the structure of your "Booking" table ? It sounds like, you will create a record in Booking table, and you should be able to generate (insert) an invoice for the booking.