Easy
What does the following PL/SQL code do?
DECLARE
CURSOR emp_cursor IS SELECT first_name, last_name FROM employees;
v_first employees.first_name%TYPE;
v_last employees.last_name%TYPE;
BEGIN
OPEN emp_cursor;
LOOP
FETCH emp_cursor INTO v_first, v_last;
EXIT WHEN emp_cursor%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(v_first || ' ' || v_last);
END LOOP;
CLOSE emp_cursor;
END;
Author: Koala rareStatus: PublishedQuestion passed 4 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
0
What is the result of this Oracle query?0
How to remove all data from an Oracle table without logging the transaction history?0
What type of join returns all rows in the left-hand table, even if they have no match in the right-hand table?0
What happens after executing this code in Oracle?0
What is the main function of the `DBMS_SCHEDULER` package in Oracle?0
How to rename a column in an existing table in Oracle?0
Which Oracle tool can be used to analyze SQL query performance?