In the following PL/SQL block, determine the values and data types for each of the following cases: DECLARE   v_customer VARCHAR2(50) := 'Womansport2';     v_credit_rating VARCHAR2(50) := 'VERY_GOOD'; BEGIN   DECLARE   v_customer NUMBER(7) := 201;    v_nmae VARCHAR2(25) := 'Unisports';      BEGIN      V_credit_rating := 'GOOD';   END;   END;   The value of v customer in the nested block is:   The value ofv name in the nested block is:   The value of v _credit_rating in the nested block is:   The value of v customer in the main block is:   The value of v name in the main block is:   The value of v_credit_rating in the main block is:

Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL_NO FIRST NAME SUR_NAME DOB GENDER PHONE FAX BLOOD TYPE WEIGHT SMOKER PCR TEST 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male B 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male Negative 91122544 AB 66 YES 1005 Shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT NULLIF(phone, fax) FROM patients WHERE medical no = 1001; Answer:

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

pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp_Infor Table EmpID EmpFname EmpLname Department Salary Gender Address DOB Kuantan 01/12/1977 M 1 Mohd Ali HR 2000 3500 Ipoh 02/05/1975 F 5000 Kuala Lumpur 01/01/1984 M 1800 Georgetown 02/05/1995 Kangar 03/07/1998 8000 2 3 4 5 Azizah Chen Ananthi Manjit Suliman Kang Kulkarni Sidhu Admin Account HR Admin 1. Write the query to display all the records in the Emp_Infor table. FM 2. Write a query to display the number of employees working in the department 'HR'. 3. Write a query to display the EmpFname from the EMP_Infor table and use the ALIAS name as Staff Name..