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..
Operator precedence-pl/sql expressions , Operator Precedence The operati...
Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op
Biochemical origin of life - modern concept, BIOCHE M ICA L ORIGIN OF LI...
BIOCHE M ICA L ORIGIN OF LIFE - It is generally agreed by astronomers, geologists and biologists that the earth is approximately 4500-5000 million years old. It is an
Stored subprograms, Stored Subprograms Normally, tools (like Oracle Fo...
Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become
Difference between 9i & 10g, Difference between 9i & 10G When Oracle r...
Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle
Using the collection methods, Using the Collection Methods The collecti...
Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain:
Majority of differences among 9i-10g-11g, Majority of Differences among 9i,...
Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s
Restriction in sql, Restriction in SQL Syntax: SELECT DISTINCT...
Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo
Using operator value in pl sql, Using Operator VALUE: As you may expec...
Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable. For illustration, to return a
Effect of anonymous columns, Effect of Anonymous Columns Now, recall t...
Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat
Advantages of packages, Advantages of Packages The benefits of the Pack...
Advantages of Packages The benefits of the Packages are as shown below: Modularity The Packages encapsulate logically associated items, types, and subprograms in the
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
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Terms & Conditions
Copyright by ExpertsMind IT Educational Pvt. Ltd.