Re: A PL\SQL Questions

I´m not shure what you mean, but a simple way would be

Select ' The number of cusomter accounts is: '||count(*) from customer_accounts;

The return is what you want...

Frank <fcolon_at_onebox.com> schreef in berichtnieuws 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 Thu Aug 16 2001 - 14:09:07 CEST