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 27 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
0
What is the main function of the `DBMS_SCHEDULER` package in Oracle?0
What happens after executing this code in Oracle?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
How to remove all data from an Oracle table without logging the transaction history?1
What is the result of this Oracle query?0
How to rename a column in an existing table in Oracle?1
What type of index is recommended for columns with few distinct values in Oracle?