From kgel@ppoone.com Fri, 27 Jul 2001 06:35:44 -0700 From: Kevin Lange Date: Fri, 27 Jul 2001 06:35:44 -0700 Subject: RE: formatting DBMS_OUTPUT Message-ID: MIME-Version: 1.0 Content-Type: text/plain Close, but you have an extra parenthesis: DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) should be DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x, '999,999')) -----Original Message----- Sent: Friday, July 27, 2001 8:52 AM To: Multiple recipients of list ORACLE-L Try DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: JRicard982@aol.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: kgel@ppoone.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).