Customer Service Chat
Get quote & make Payment
oracle development , PL-SQL Programming
Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive details about each customer, the number of bookings that customer has made and the total cost of all completed rentals for that customer.
1. Use a fully declared explicit cursor to find and display comprehensive details for each customer.
2. Use an implicit cursor and a SQL function to calculate the number of bookings the customer has made. Display the number of bookings.
3. Calculate the total cost. In order to calculate the total cost, you may not use any SQL functions (e.g. SUM) and you must find a way of using local variables to do the arithmetic. Only completed rentals are used in this calculation. When miles_in has a value, the rental is complete. Display the total cost when the computation is complete.
Submit the code and a screen dump of the output when the program is run.
Posted Date: 10/30/2012 5:29:55 AM | Location : United States
Ask an Expert
oracle development , Assignment Help, Ask Question on oracle development , Get Answer, Expert's Help, oracle development Discussions
Write discussion on oracle development
Your posts are moderated
Write your message here..
Loop labels- iterative control, Loop Labels Like the PL/SQL blocks, loop...
Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP
Fetch statement - syntax, FETCH Statement The FETCH statement retrieve ...
FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t
Package body, The Package Body The package specification is implemented...
The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p
In out mode - parameter modes, IN OUT Mode An IN OUT parameter passes ...
IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts
Pragma restrict_references in pl sql, Using Pragma RESTRICT_REFERENCES: ...
Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,
Constants and variables in pl sql, Constants and Variables: You can...
Constants and Variables: You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor
Theory of biogenesis, THEORY OF BIOGENESIS - This theory explains th...
THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or
Product-specific packages, Product-specific Packages The Oracle and dif...
Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus
Seeking a programmer to design a legal document, Seeking a programmer to de...
Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int
Cursors, What is Cursors how to use it in Real time application ?
What is Cursors how to use it in Real time application ?
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
IT Courses and Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.