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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Introduction to Java Programming, Comprehensive Version
Authors: Y. Daniel Liang
10th Edition
133761312, 978-0133761313
