Re: A PL\SQL Questions
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 03 Aug 2001 21:53:20 GMT
Message-ID: <k3Fa7.417789$p33.8440769_at_news1.sttls1.wa.home.com>
Date: Fri, 03 Aug 2001 21:53:20 GMT
Message-ID: <k3Fa7.417789$p33.8440769_at_news1.sttls1.wa.home.com>
You are using just sql in your example.
select 'The number of customer accounts is:' ||count(*) from
customer_accounts;
"Frank" <fcolon_at_onebox.com> 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 03 2001 - 23:53:20 CEST