
Using PUT_LINE in the DBMS_OUTPUT Package
REM set server output to ON to display output from dbms_output
SET SERVEROUTPUT ON
BEGIN
dbms_output.Put_line('These are the tables that '
||USER
||' owns:');
FOR item IN (SELECT table_name
FROM user_tables)
LOOP
dbms_output.Put_line(item.table_name);
END LOOP;
END;
/
OUTPUT:-
These are the tables that HR owns:
EMP_AUDIT
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
COUNTRIES
EMPLOYEES
JOB_HISTORY
PL/SQL procedure successfully completed.

0 comments:
Post a Comment