use of variables in pl/sql

From: Peter Shankey <shankeyp_at_charlestoncounty.org>
Date: Tue, 03 Nov 1998 09:58:42 -0500
Message-ID: <363F1A22.B05F5B75@charlestoncounty.org>

Given the block:

declare

        cursor tab_cursor is select table_name from sys.dba_tables where owner = 'CHADBA';

        my_table_name varchar2(30); BEGIN
    open tab_cursor;
    loop

        fetch tab_cursor into my_table_name;
        exit when tab_cursor%notfound;
        dbms_output.put_line('table name is:  ' || my_table_name);
        select * from my_table_name;

    end loop;
    close tab_cursor;
END;
/

Why can not I substiutue the var my_table_name on the select statement and get a dump of the tables? Is there a way to do this? Received on Tue Nov 03 1998 - 08:58:42 CST