1. 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 Students; line cursorl %type; | BEGIN OPEN cursor1; LOOP SELECT cursorl inside line; I DBMS_OUTPUT PUT_LINE(frst name= "| line. finame || last name="line. Iname); EXIT WHEN Cursor %FOUND; END LOOP; CLOSE cursor1; END;

1. 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 Students; line cursorl %type; | BEGIN OPEN cursor1; LOOP SELECT cursorl inside line; I DBMS_OUTPUT PUT_LINE(frst name= "| line. finame || last name="line. Iname); EXIT WHEN Cursor %FOUND; END LOOP; CLOSE cursor1; END;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

1. Write a PL/SQL program using an explicit cursor that displays all patients PLCO_ID numbers from the colo_proc_data table on the screen if the patients’ procedure is biopsy, the procedure is staging, interval status of linked cancer is never screened, the procedure type is invasive Scopes, biopsies, & surgeries, the procedure type is Lymphadenectomy/Lymph Node Sampling, and the procedure result is abnormal, confirmed metastasis.
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. The state names are abbreviated. You want to check for state names that are greater than 2 characters long. You write the SQL query below. Add a LENGTH function that will return any state names that are greater than 2 characters long.
Let's wa(k through a review of basic SQL syntax, using as an example the database that was mentionedearlier. This database has the following simple structure(* indicates a primary key):Courses: CourseID*, CourseName, TeacherIDTeachers: TeacherID*, TeacherNameStudents; StudentID*, StudentNameStudentCourses: CourseID*, StudentID*Using the above table, implement the following queries.Query 1: Student Enrollment Query 2: Teacher Class Size
PostgreSql differs from the SQL Standard primarily by requiring which of these constructs. a. reference to either the old row or new row b. begin and end c. stored trigger function d. trigger credentials
In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and department_id of all employees and a second query listing employee_id, job_id, start_date, and department_id from the job_history table and combine the results as one single output. Make sure you suppress duplicates in the output.
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. You want to check for postal codes that are greater than 7 characters long. You write the SQL query below. Add a LENGTH function that will return any postal codes that are greater than 7 characters long.
INFO 2303 Database Programing Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output: Enter the patient ID: 168 The status of X-immunization : REQUIRED
Given the following SQL statement, which statement is most accurate?SELECT customer# FROM customersJOIN orders USING(customer#)WHERE shipdate-orderdate IN(SELECT MAX(shipdate-orderdate) FROM ordersWHERE shipdate IS NULL);a. The SELECT statement fails and returns an Oracle error message.b. The outer query displays no rows in its results because the subquery passes a NULLvalue to the outer query.c. The customer number is displayed for customers whose orders haven’t yet shipped.d. The customer numbers of all customers who haven’t placed an order are displayed
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;
The map function is equivalent to the SQL WHERE clause. True or false? (A) True (B) False
Which of the following is not a type of mismatch that occurs while mixing SQL with other procedural languages? Choose an answer A Data type mismatch B Compiler-time mismatch C Processing mismatch D Run-time mismatch
ASSUME 6.2 IS DONE Write a SQL statement to get the list of all the tasks that started after2022-05-10. Include all the columns from the task table. Write a SQL statement that returns a list of the team members with alltheir tasks. Include the team member’s name and the description ofthe task in the results. Write a SQL statement to get a list of the tasks in the database,arranged by duration from largest to smallest. Include all the columnsfrom the Task table.