How do I use a varchar variable to specify a tablename in a SELECT statement???
e.g. i want to write a procedure which accept table name as input and print the number of records in it;
create or replace procedure a(tblName in varchar) is
result long;
begin
select count(*) into result from tblName;--error on this line
dbms_output.put_line(result);
end a;