Substituting table_name in pl/sql

Hi Guys, I am totally new to pl/sql. I am trying to substitute the table name in a select query with a variable but I don't know how to do that. Please help.

Here's the script:
>>>>>>>>

DECLARE

        x NUMBER;
        y NUMBER;
        TABNAME CHAR(150); 
BEGIN
        x := 1;
FOR channel IN (
         SELECT PLGRPID FROM PLGROUP)
        LOOP
                TABNAME := 'PLGRPMSG'||x;
                SELECT COUNT(*) INTO y FROM TABNAME;
                DBMS_OUTPUT.PUT_LINE(TABNAME);
                x := x+1;
        END LOOP;

<<<<<<<<

Thanks,

Yasin Received on Wed Apr 02 2003 - 22:23:45 CEST