Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to display result from PL/SQL Procedure??

Re: How to display result from PL/SQL Procedure??

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 21 Sep 1999 12:49:43 GMT
Message-ID: <1095qx@questionexchange.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US