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 24 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
0
What type of join returns all rows in the left-hand table, even if they have no match in the right-hand table?1
What type of index is recommended for columns with few distinct values in Oracle?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 remove all data from an Oracle table without logging the transaction history?0
Which Oracle tool can be used to analyze SQL query performance?0
How to rename a column in an existing table in Oracle?