2) Evaluate the PL/SQL block and determine the data type andvalue of each of the following variables according to the rules ofscoping.DECLAREv_weightNUMBER (3) := 600;VARCHAR2 (255) := 'Product 10012';v_messageBEGINA. v_weight at position 1DECLAREB. v_new_locn at position 1v_weightv messagev_new_locnNUMBER ( 3) :- 1;VARCHAR2 (255) := 'Product 11001';VARCHAR2 (50) := 'Europe';C. v_weight at position 2BEGINv_weight :- v_weight + 1;v new locn := 'Western ' || vD. v_message at position 2v_new_locn;E. v_new_locn at position 2END;v_weight := v_weight + 1l;v_message := v_message || ' is in stock';v_new_locn := "Western ' || v_new_locn;2END;Save your scripts as Tech11_fullnameWrite your answers below:A.В.C.D.Е.iveNST

2) Evaluate the PL/SQL block and determine the data type and value of each of the following variables according to the rules of scoping. DECLARE v_weight NUMBER (3) := 600; VARCHAR2 (255) := 'Product 10012'; v_message BEGIN DECLARE A. v_weight at position 1 B. v_new_locn at position 1 NUMBER ( 3) := 1; VARCHAR2 (255) := 'Product 11001'; v_weight v_message v_new_locn VARCHAR2 (50) C. v_weight at position 2 := 'Europe'; BEGIN v_weight :- v_weight + 1; v_new_locn := 'Western I| v_new_locn; D. v_message at position 2 V END; E. v_new_locn at position 2 v_weight := v_weight + 1; v_message := v_message || 'is in stock'; v_new_locn :- 'Western ' || v_new_locn; END; Save your scripts as Tech11_fullname Write your answers below: A. В. c. D. E. NST

2) Evaluate the PL/SQL block and determine the data type and value of each of the following variables according to the rules of scoping. DECLARE v_weight NUMBER (3) := 600; VARCHAR2 (255) := 'Product 10012'; v_message BEGIN DECLARE A. v_weight at position 1 B. v_new_locn at position 1 NUMBER ( 3) := 1; VARCHAR2 (255) := 'Product 11001'; v_weight v_message v_new_locn VARCHAR2 (50) C. v_weight at position 2 := 'Europe'; BEGIN v_weight :- v_weight + 1; v_new_locn := 'Western I| v_new_locn; D. v_message at position 2 V END; E. v_new_locn at position 2 v_weight := v_weight + 1; v_message := v_message || 'is in stock'; v_new_locn :- 'Western ' || v_new_locn; END; Save your scripts as Tech11_fullname Write your answers below: A. В. c. D. E. NST

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Function is in pl/sql
In Oracle PL/SQL programming language, %TYPE keyword would give you some advantages when you are declaring local variables. Describe at least one but maximum two benefits of %TYPE usage.
Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: ) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_idas an input parameter to show its corresponding node id to the banker. Then execute this procedure withcust_id=5.
T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. HINT use cursor instructions as a template for the problem. Instructions goes as follows CREATE PROCEDURE usp_DISP_REP_CUST @repnum char(2) AS DECLARE@custnum char(3) DECLARE@custname char(35) DECLARE mycursor CURSOR READ_ONLY FOR SELECT CUSTOMER_NUM, CUSTOMER_NAME FROM CUSTOMER WHERE REP_NUM = @repnum OPEN mycursor FETCH NEXT FROM mycursor INTO @custnum, @custname WHILE @@FETCH_STATUS=0 BEGIN PRINT@custnum+' '+@custname FETCH NEXT FROM mycursor INTO @custnum, @custname END CLOSE mycursor DEALLOCATE mycursor
ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
In SQL code: Create a PL/SQL block to retrieve the name of each employee from the EMPLOYEE table and print the first initial of each name on the screen, incorporating an INDEX BY table.
Adjust the following information so that1) all users on the system are able to run the SQL Executable and 2) multiple users (such as a team of software engineers) have the power to modify the SQL Executable Introduce any new groups that are needed and assign them group IDs USERS SQL Manager UID: 3 GROUPS SQL Users GID: 5 FILESDatabase File Owner 3 Group NA owner: rw group: - world: - setUID: 0 setGID: 0 sticky: 0 SQL Executable Owner 3 Group 5 owner: rwx group: r-x world: - setUID: 1 setGID: 0 sticky: 0
Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.
SQL procedure a. Write a procedure in SQL that inserts a new customer record into the "Customers" table. b. Create a procedure that updates the quantity of a product in the "Inventory" table based on the product ID. c. Write a procedure that calculates the average salary of all employees in the "Employees" table and displays the result.
Problem Your task is to write an SQL query that uses SQL's time constants to dynamically determine the timezone the database server is configured to use. Your query should return the timezone as a single string value with the timezone offset relative to the Coordinated Universal Time (UTC). The single output column should be named tz_offset, and the value should be in the form: UTC: where and use two digits in 24-hour format, padded with leading zeroes if necessary. Example: if the server used India's timezone the output should be: | tz_offset | | UTC+05:30 (1 row) query.sql> init.sql 1