Write PL/SQL Procedure/Function that accepts 4 parameters, 2 integers representing product ID, and 2 numbers representing their
Fantastic news! We've Found the answer you've been seeking!
Question:
Write PL/SQL Procedure/Function that accepts 4 parameters, 2 integers representing product ID, and 2 numbers representing their prices. The stored procedure/function determines which product has the higher price and returns the ID of that product. If you write stored procedure, you need an extra parameter of type integer to store the returning value from the stored procedure. If prices are the same, then the stored procedure returns 1. It returns -1 if an error occurs.
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date: