Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

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.

Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-