Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information.
Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the user that an invalid Region_id is entered.
Remember to use the Sequence Store_seq to generate the StoreRoom_ID
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: