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

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