Which of the following is the syntax to fetch from a cursor variable Answer

Which of the following is the syntax to fetch from a

This preview shows page 24 - 26 out of 70 pages.

Which of the following is the syntax to fetch from a cursor variable? You want to display all records in the database whose salary is above the salary of Alexander Hunold. Procedure can be stored in the database as a schema object. In PL/SQL Block Structure, which of the following are mandatory? PL/SQL stands for Which of the following is CORRECT about sub-queries? Which of the following does NOT describes SELECT Statement in a PL/SQL. PL/SQL Provides a block structure for executable units of ________________. Evaluate the SQL commandSELECT employee_id, salary from employees where salary = ANY (SELECT salary FROM employees WHERE job_id = 'IT_PROG') AND job_id = 'ST_CLERK' Which of the following PL/SQL will execute successfully? In PL/SQL Block Structure, which of the following are OPTIONAL? Evaluate the following PL/SQL. At what line number is the error of the PL/SQL?
Image of page 24
EXCEPTION WHEN e_invalid THEN DBMS_OUTPUT.PUT_LINE('No such department id.'); END; Answer: 7What is the error trapping function that returns the numeric value of the error code? Fetch into a record when fetching from a cursor. Which of the following is the syntax to open a cursor varial FOR select_statement;Which of the following is the syntax to define a REF CURSOR type? Evaluate the following. What will be the output?
Image of page 25
Image of page 26

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture