select in pl/sql

[CliffW]

You would need to use an explicit or implicit cursor, then use DBMS_OUTPUT.put_line to print the result in SQL*.

Explicit cursor in an anonymous PL/SQL block:

DECLARE
CURSOR emp_cur IS
SELECT * FROM emp;
BEGIN
FOR rec IN emp_cur
LOOP
DBMS_OUTPUT.put_line(rec.empno || ', ' || rec.ename);
END LOOP;
END;
/


Hope this helps.

CliffW