Question: Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner whose number currently is

Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner whose number currently is stored in I_OWNER_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. b. Obtain the office number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID. Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_PROPERTY_ID, I_ADDRESS, I_OWNEER_NUM, I_FIRST NAME, and I_LAST_NAME. c. Add a row to the OWNER table. d. Change the last name of the owner whose number is stored in L_OWNER. NUM to the value currently found in I LAST NAME

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!

Question - 4 Parts : Write PL/SQL or T-SQL procedures to accomplish the following tasks: 1. Obtain the first name and last name of the owner whose number currently is stored in I_OWNER_NUM. Place...

4. Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner who'se number currently is stored in 1_OWNER_NUM. Place the be values in the...

Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the first name and last name of the owner whose number currently is stored in 1_OWNER_NUM. Place these values in the...

5. Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in...

4. Write PLISQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place...

ok it has to be in Oracle. i tried to do part A on my own but I keep getting errors below is a screenshot of what I tried. if the rest of the parts are answered even better thank you 5. Write MySQL,...

Write MySQL , PL / SQL , or T - SQL procedures to accomplish the following task: a . Obtain the name and credit limit of the customer whose ID is currently stored in I _ CUST _ ID . Place these...

Using Colonial Adventure Tours database (pictured below) to complete the following exercises. c. Add a row to the GUIDE table. d. Change the last name of the guide whose number is stored in L_GUIDE...

IN A SQL Database Model: StayWell Staywell finds and manages accommodation for owners of student accommodation in the Seattle Area. The company rents out and helps to maintain 15-bedroom properties...

Write PL/SQL a. Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and...

Homewood Co. commonly finances some of its U.S. expansion by borrowing foreign currencies (such as Japanese yen) that have low interest rates. Describe how the potential return and risk of this...

Consider a firm for which the nominal required rate of return is 8 percent. The rate of inflation is 3 percent. Compute the P/E ratio of the firm under the following situations: i. The firm has a...

Stock volatility ultimately is due to new information about the firm or the market the current tax rate the current interest rate

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

For each of the following situations, indicate whether the direct or the indirect organizational plan would be most appropriate and why. (Objective 2) a. One of your sales representatives applied for...

Explain why spell checkers and style checkers do not replace proofreading. (Objective 2 )

Using the indirect plan, indicate the most coherent order for these sentences by listing their letters in that order: a. The evening meal is a perfect time for families to talk and share events of...