We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
Writing a SQL Plus Stored Procedure
Posted on 2004-10-17
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
So to clarify, you need to Insert the new Values of an Invoice, which you want to create, into your "INVOICE" table, then your going to create a report off of this? Where will fields like "Total_Amount" and "Due_Date" and "Amount_Paid" be derived from? Are these values which will be passed in from other sources in the DB, or from an application?
Are you aware of Oracle's Sequences, I take it from your statement above you are. You can use this to create your Invoice Number. Invoice_Date would just be SYSDATE, the last three fields would need to be passed in or gotten from other sources in your DB.
Are you aware of Oracle's Sequences, I take it from your statement above you are. You can use this to create your Invoice Number. Invoice_Date would just be SYSDATE, the last three fields would need to be passed in or gotten from other sources in your DB.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
(CODE)
This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month10 days, 12 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.