Write a PL/SQL script that prompts the user to enter a car serial number and displays:[USE SI.Car
Fantastic news! We've Found the answer you've been seeking!
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 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.
Related Book For
Introduction to Java Programming, Comprehensive Version
ISBN: 978-0133761313
10th Edition
Authors: Y. Daniel Liang
Posted Date: