Question 15Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program.DECLARECURSOR cursorl IS SELECT FROM Students;line cursorl %type;BEGINOPEN cursorl,LOOPSELECT cursorl inside line;DBMS OUTPUT PUT LINE('first name= '|| line.fname || 'last name='||line.Iname);EXIT WHEN Cursor %FOUNDEND LOOPCLOSE cursor1;END;

Ans:) In this PL/SQL block there are some errors in the syntax. The correct syntax for the…

Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program DECLARE CURSOR cursorl IS SELECT FROM Students3; line cursorl %type; BEGIN OPEN cursorl3B LOOP SELECT cursorl inside line DBMS OUTPUT PUT LINE('first name= '|| line.fname || 'last name='|line.Iname)3B EXIT WHEN Cursor %FOUND END LOOP CLOSE cursorl, END;

Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program DECLARE CURSOR cursorl IS SELECT FROM Students3; line cursorl %type; BEGIN OPEN cursorl3B LOOP SELECT cursorl inside line DBMS OUTPUT PUT LINE('first name= '|| line.fname || 'last name='|line.Iname)3B EXIT WHEN Cursor %FOUND END LOOP CLOSE cursorl, END;

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

YOu have to find SQL code of all and show output
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Writes a PL/SQL function that calculates the factorial of a number passed as a parameter. The Factorial of a number n is defined as −0! = 1n! = n*(n-1)*(n-2)*(n-3)... 1 for n > 0
Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare vAddress employee.Address%VR0WTYPE; begin select ename , address into vAddress from employee where salary = 1500; DBMS_OUTPUT.PUT_LINE('NOM =' || vEname || 'Adresse=' || vAddress ); exception when MANYROWS then dbms_output.put_line("This query returned many rows"); end;
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.
Using language program PL/SQL
//trying to make recursive SQL statement to get the days of the week , can you tell me what does not work in this query: WITH cte_number (counter, weekday) AS(SELECT 0, Datename(DW,0) UNION ALLSELECTcounter+1, Datename(DW, counter+1)FROM cte_numberwhere counter<6) select weekday from cte_number; //thanks for you assistance
Explain set operator in SQL
Write a p l SQL program to print the following series 2, 8,11....50
SQL Database Write PL/SQL 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 these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_ LAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME. Delete the guide whose number is stored in I_GUIDE_NUM
QUESTION 15 Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare employeeRecord employee%TYPE; ename varchar2; begin fetch ename, salary inside employeeRecord from employee where enum = 'E8'; DBMS_OUTPUT.PUT_LINE(employee.ename||' '|| employee.Salary); end;