Re: A PL\SQL Questions

From: Arif Huque <arif_huque_at_bluecurve.co.uk>
Date: 17 Aug 2001 06:53:26 -0700
Message-ID: <4a226ee2.0108170553.709a8ab2_at_posting.google.com>


SELECT 'TEXT HERE' || count(*) FROM table_name

fcolon_at_onebox.com (Frank) wrote in message news:<3271719f.0108031221.77749dec_at_posting.google.com>...
> Quick question....is there a way to get a PL\SQL query to print some text?
>
> For example, if I had the query:
>
> Select count(*) from customer_accounts; (will return a count of 10)
>
> How can I change that query so that the following prints out:
>
> The number of cusomter accounts is: 10
>
> Thanks.
>
> --Frank
>
> P.S. Do you know of any good PL\SQL resources on the net?
Received on Fri Aug 17 2001 - 15:53:26 CEST

Original text of this message