Re: pl/sql greatest function

From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/05/24
Message-ID: <4o4i4v$lli_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1


The dbms_output package is designed to output messages. Why not determine the greatest value within a select statement or plsql expression into a plsql variable (v_val). Then use the dbms_output package to report on the results. IE:

 dbms_output.put_line('The greatest value is "||to_char(v_val));

Check out server application developers guide rel 7-2 _at_page 6-27.

John. Received on Fri May 24 1996 - 00:00:00 CEST

Original text of this message