Question: Write a PL/SQL script that prompts the user to enter a car serial number and displays:[USE SI.Car table 5 Marks] The name of the owner


Write a PL/SQL script that prompts the user to enter a car serial number and displays:[USE SI.Car table 5 Marks]

The name of the owner if the car has an owner

'Car has no owner' if the car does not have an owner.

'There is no such car' if the serial number entered by the user does not match any records in the car table

Use Oracle's NO_DATA_FOUND build in exception to display the last message.






Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Q:

I need some help and explanation will be a text-based .cpp file including your C++ program and a text-based .sql file including your Oracle stored procedures for the Database Application ....

Q:

You are designing a new syntax for a programming language like Java, with the intention of making it more approachable to students by using English words instead of punctuation symbols. (a) How does...

Q:

For these questions you must use the tables created in your own schema, because you DO NOT have privileges to INSERT, UPDATE or DELETE values in SI schema. Write a stored procedure that can be used...

Q:

DataBase MAnagement Write a stored procedure that can be used to find the number of cars and total amount of money a customer has spent on all cars they have bought. This procedure will be used in...

Q:

Write a stored procedure that can be used to find the number of cars and total amount of money a customer has spent on all cars they have bought. This procedure will be used in question 2, but it can...

Q:

these pictures are the figures that are mentioned in the passage Specialty Imports Specialty Imports is an automobile dealership located on the "auto strip" in North-West Brampton (where several...

Q:

Starter Text File: create table Worker ( WID number (9) Constraint pk_Wkr primary key, First_Name varchar2 (30) constraint nn_FN not null, Last_Name varchar2 (30) constraint nn_LN not null, MI...

Q:

Give Correct ANSWERS Human-Computer Interaction (a) If you had been one of the original inventors of the WIMP interface, and engineers on the technical team had been sceptical about the advantages...

Q:

Suppose there is an urn containing 300 balls, of those 100 balls are red, while the remaining 200 balls are either black or white with unknown proportions. The balls are well-mixed that any...

Q:

2. Of all people who enter Roosters Coffeehouse, 79% order a beverage, 53% order food, and 45% orderboth a beverage and food. (a) You plan to select one customer at random. Explicitly define the two...

Q:

Simon Forest Corporation operates two divisions, the Timber Division and the Consumer Division. The Timber Division manufactures and sells logs to paper manufacturers. The Consumer Division operates...

Q:

On September 3 0 , 2 0 2 3 , Peace Frog International ( PFI ) ( a U . S . - based company ) negotiated a two - year, 1 , 9 0 0 , 0 0 0 Chinese yuan loan from a Chinese bank at an interest rate of 4...

Q:

Mrs. Sandhu placed $11,500 in a four-year compound-interest GIC earning 3.75% com-pounded monthly. What is the GIC's maturity value?

Q:

Selected accounts for Winslow Inc., a private company following ASPE, as at December 31, 2020, are as follows: Instructions Prepare closing entries for Winslow Inc. on December 31, 2020. S 60,000...

Q:

Prove that if p is prime and 0

Q:

A home improvement centre buys a shop vacuun1 for $38. Operating expenses are estimated to be 35% of cost, and desired operating profit is 45% of cost. a. What price should be charged for the vacuum?...

Q:

Using the information from BE5-9, prepare a retained earnings statement for the year ended December 31, 2008. Assume an error was discovered: land costing $80,000 (net of tax) was charged to repairs...

Q:

Using the following information as a framework, do you agree or disagree with the framework? Why or why not? Priceless Outcome #4: Retention When companies fail to create workplace excellence and...

Q:

Write a program that uses a bar chart to display the percentages of the overall grade represented by projects, quizzes, midterm exams, and the final exam, as shown in Figure 14.46b. Suppose that...

Q:

Programming Exercise 22.8 stores the prime numbers in a file named PrimeNumbers.dat. Write a program that finds the number of prime numbers that are less than or equal to 10, 100, 1,000, 10,000,...

Q:

A self-avoiding walk in a lattice is a path from one point to another that does not visit the same point twice. Selfavoiding walks have applications in physics, chemistry, and mathematics. They can...

Q:

A recent article in Bloomberg Businessweek listed the Best Small Companies. We are interested in the current results of the companies sales and earnings. A random sample of 12 companies was selected...

Q:

The following sample observations were randomly selected. a. Determine the regression equation. b. Determine the value of y when x is7.

Q:

Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of rooms in a private single-family residence. A random sample of 10 homes...