Question
Write an PL/SQL anonymous block program unit that display vendors names (VENDOR_NAME), full address (VENDOR_ADDRESS1, VENDOR_CITY, VENDOR_STATE,VENDOR_ZIP_CODE ) for those vendors who live in a
Write an PL/SQL anonymous block program unit that display vendors names (VENDOR_NAME), full address (VENDOR_ADDRESS1, VENDOR_CITY, VENDOR_STATE,VENDOR_ZIP_CODE ) for those vendors who live in a user-input city (substitution variables '&VEN_CITY').
Try two cases (case sensitive):
City: Chicago
City: Washington
The column names are in () and are all varchar2 data types.
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
Data Driven Decisions Harnessing The Power Of Social Media Analytics To Boost Your Marketing Strategy
Authors: Franklin Iroegbu
1st Edition
B0CN6VN82B, 979-8867500764
