Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to display result from PL/SQL Procedure??
> Hi all,
>
> First of all, thank you for taking time to read my posting. I
have written a
> small procedure to help me locate a department name and it's
address, how do
> i print these information onto the screen in a nice format?
Example:
>
> Department: xxxxx
> Manager: xxxxxx
>
> I try to use the following code:
> dbms_output.enable;
> dbms_output.put_line('Department: '||deptname);
> dbms_output.put_line('Manager: '||mgrlname || ', '
||mgrfname);
>
> however, i have no idea what is dbms_output.put_line and
dbms_output.enable
> mean, are they some standard commands or function or keywords
in PL/SQL
> similar to C printf statements??
>
> I really appreaciate your help very much, thanks in advance..
>
> Cheers
> Evelyn
>
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=3469&cus_id=USENET&qtn_id=3384
Received on Tue Sep 21 1999 - 07:49:43 CDT
![]() |
![]() |