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: converting so I get some kind of an output (PL/SQL)

Re: converting so I get some kind of an output (PL/SQL)

From: SKurosky <skurosky_at_aol.com>
Date: 06 Apr 2000 00:35:44 GMT
Message-ID: <20000405203544.28470.00001055@ng-fw1.aol.com>


>HAJIR WROTE:

>if ( (HD_CHECK.H_QTY_PICKED >= HD_CHECK.H_QTY_TO_SHIP) OR
> (HD_CHECK.H_QTY_SCANNED >= HD_CHECK.H_QTY_PICKED) OR
> (HD_CHECK.H_QTY_SHIPPED >= HD_CHECK.H_QTY_SCANNED) )
> THEN
> H_QTY_OK := FALSE ;
>END IF;
>
>What should I do to this if statement so I get some kind of an output.
>What is the print functionality? I want to print out the quantities.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>
>Hi

Use DBMS_OUTPUT.PUT_LINE
Set SERVEROUTPUT ON first
hth
S

>
>
>
Received on Wed Apr 05 2000 - 19:35:44 CDT

Original text of this message

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