Re: PL/SQL naming a table

You will need to use dynamic pl/sql. Should be pretty simple. All you'd change each time is the actual table name.

Ken

Roberto Diaz wrote:

> Hi!
>
> Just i would like to know how to make a simple procedure to count the rows
> of any table..
>
> something like this:(but well-formed)
>
> create procedure contar (tabla IN varchar2)
> AS
> BEGIN
> select count(*) from tabla;
> END contar;
Received on Mon Aug 23 1999 - 07:23:21 CDT