Write an anonymous block that places a substitution variable

Assignment Help Computer Engineering
Reference no: EM13337320

Question 1-

Write an anonymous block that places a substitution variable (&) into a local variable of type character. You should check the value entered in the local variable and output different messages depending on the value provided.

  • If value is 'A', output: 'Please proceed to Level 1'
  • If value is 'B' or 'C', output: 'Please proceed to Level 2'
  • If value is 'D', output: 'Please proceed to Level 3'
  • In all other entries, output: 'Invalid Entry'

Question 2 -

Create a host (or global) variable named G_NEWVALUE.

Write an anonymous block that declares two local variables: A1RATE and B2RATE. The data types of these two variables should be the same as the data type of the column rate_per_mile in i_cargroup table. Also declare a constant called SURCHARGE with value 5.

In your BEGIN section, write two SELECT queries to obtain value of the rate_per_mile column where car_group_name is 'A1' and 'B2' and assign the corresponding values to A1RATE and B2RATE variables. Now use the IF-THEN statement to compare the two variables and add the  constant SURCHARGE to the smaller value.  Assign the new sum to the variable G_NEWVALUE.

Using the PRINT command, output the value in the host variable (G_NEWVALUE) after the anonymous block has run.

 Question 3 -

 Write an anonymous block that meets the following specification:

1.      Using an explicit cursor, retrieve each row from the i_car table.

2.      Create a local variable that inherits the structure of the i_car table (using %ROWTYPE attribute). Place each row returned into this variable.

3.      Using an implicit cursor, calculate the number of bookings that belong to each car.

4.      Display the car registration, car group name, model name, cost and the number of bookings for each car.

Question 4 -

Write a PL/SQL that displays the maximum miles driven from the odometer reading  for all the car bookings. Your program must use at least one explicit cursor and must NOT use any functions, for example SUM, MAX, COUNT, etc.

(Hint: miles driven from the odometer reading for each booking can be found by subtracting miles_out column from miles_in column, i.e. miles_in - miles_out)

Reference no: EM13337320

Questions Cloud

The universality of the portable document format : With the advent of scanners and the universality of the portable document format (PDF), the market for optical copiers is shrinking rapidly. Can a company such as Xerox Corporation survive?
Prepare the service revenue budget for 2012 : Prepare the service revenue budget for 2012 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue
Find at what rate is the spring doing work on the mass : The mass has a kinetic energy of 17.0 J as it passes through its equilibrium position (the point at which the spring force is zero). At what rate is the spring doing work on the mass
What is the total force the person must apply : A person is pushing a uniformly-loaded 24.15 kg wheelbarrow along a plank that makes an angle ? = 38.0° with the horizontal. What is the total force the person must apply
Write an anonymous block that places a substitution variable : Write a PL/SQL that displays the maximum miles driven from the odometer reading  for all the car bookings. Your program must use at least one explicit cursor and must NOT use any functions, for example SUM, MAX, COUNT, etc.
Find the magnitude of the total acceleration : A race car accelerates uniformly from a speed of 39.0 m/s to a speed of 64.0 m/s in 5.00 s while traveling clockwise around a circular track of radius 4.40 102 m. Find the magnitude of the total acceleration when the speed is 40.0 m/s
What is the magnitude of the larger of the two resistances : When a 45.0-V emf device is placed across two resistors in series, a current of 15.0 A is flowing in each of the resistors. When the same emf device is placed across the same two resistors in parallel,
How do two tables are true relationship tables : Howw do two tables are 'True relationship tables'
What are the total costs and total variable costs : Gizmos, Inc. produces gizmos at an average total cost (ATC) of $20 and an average variable cost (AVC) of $15. The only fixed input used in the production of gizmos costs $20. What are the total costs (TC) and total variable costs (TVC) of Gizmo’s cur..

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  A comfort level with the switches and maybe routers

Do you feel comfortable working with network infrastructure itself.

  Define a brief discussion of the technical aspects

Plagiarism is "cheating." It will not be tolerated and will be dealt with in accordance with University policy. Automated tools will be used to detect plagiarism and I will make deductions for minor cases, and grade the paper as a zero for major..

  Define current and emerging nonvolatile ram technologies

List and explain current and emerging nonvolatile RAM technologies. What advantages are potentially offered by the emerging technologies as compared to current flash RAM technology?

  Cache simulator lab

Find a way to simulate different cache architectures through premade address accessing files and this task includes modifying the associativity

  Write a program that reads 100 numbers

design a program in python that continually reads in numbers from the user and adds them together until the sum reaches 100. Write another program that reads 100 numbers from the user and prints out the sum.

  What some of the most common symptoms of malware

What are instance of harmful spyware application? What risk or threat do they pose to workstation domain.

  What are pros and cons of society''s increasing reliance data

What are pros and cons of society's increasing reliance data

  Design and populate tables within a database

Employees all have employee ID's, first names, last names, middle initials, street addresses, city, state, postal codes, and a date of birth.

  Discuss the layered stack approach

This is meant as a discussion topic, this is not an essay. Describe the OSI and TCP/IP reference models. express  the similarities and differences between them. consider how the layered stack approach assists in our understanding of these referenc..

  Create a testrectangle class in java

An overloaded constructor that takes integer width and height arguments, uses a separate method to check whether the width and height fall within the range between 0 and 30, and throws an exception if out of range.

  What condition is it appropriate to buy commercial

Under what condition is it appropriate to develop software in house and Why? Under what circumstances is it appropriate to commission development of custom software? Why? Under what circumstance is it appropriate to buy commercial or COTS software..

  What address would virtual address 1053 translate to

All numbers are decimal, everything is numbered starting from 0, and all addresses are memory byte addresses. The page size is 1024 bytes.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd