Re: when is a variable not a variable

John Steinbach wrote:
> FOR x IN c_tables LOOP
> v_name := x.table_name;
> SELECT COUNT(*) INTO v_count
> FROM v_name;
> The following code does not work. I was tring to get a row count of all my
> table spaces without hardcoding the table names.
>
> Any Thoughts?

Dynamic SQL is not quite that simple. You find the functions you need in package DBMS_SQL and instructions in pl/sql help. Received on Wed Jan 29 1997 - 00:00:00 CST