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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. [4 marks] Write a query to list a summary of customer balance for those customers who made purchase. More specifically, the summary should include the minimum balance, maximum balance, and average...

All questions are based on the Database (eCommerce.sql) below 1. [4 marks] Write a query to list a summary of customer balance for those customers who made purchase. More specifically, the summary...

Question 3 3 . 1 Create a PL \ SQL anonymous block displays book details: the book's name and category, the publisher's name and publication date, and the retail price of the book. The book should...

Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code. 2. [4 marks] Write a query to list the most popular...

All questions are based on the Database (eCommerce.sql) below [4 marks] Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by...

PLEASE USE PROPER NAMING 1. [4 marks] Write a query to list a summary of customer balance for those customers who made purchase. More specifically, the summary should include the minimum balance,...

1) Write a query to return the listing of customers who did not make purchase during the invoicing period. Sort the results by customer code. 2) Write a query to list the most popular products p_code...

CREATE TABLE birthday (B_MONTH NUMBER, B_DAY NUMBER, B_RANK NUMBER); / INSERT INTO birthday SELECT * FROM hchen .birthday; / COMMIT; / SELECT COUNT(*) FROM birthday; / Write a PL/SQL anonymous block...

The TAB_BIRTHDAY table consists of every day of the year, from January 1 to December 31, along with a ranking based on how many babies were born in the United States on that date between 1973 and...

A weir is being considered for flow measurement in a long, concrete irrigation canal with a bottom slope of 0.002. The maximum depth of flow in the 15-ft-wide canal is 6 feet, but the channel...

What are the benefits of organizational mission and values statements? How are organizational missions and strategies related to performance measures?

Taking a physical count of the merchandise is optional under a periodic inventory system. - true. - false

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

3. Read the advice column in your daily paper or an online magazine. Bearing in mind what youve read in this chapter, consider the nature of the interpersonal conflicts discussed. What are the...

Understanding Groups

4. This week, if you have a disagreement with a friend, roommate, romantic partner, family member, or boss, identify one change you could make to manage and resolve the conflict more productively....