I am using Oracle 11g. I am trying to get the table data with this procedure:
CREATE OR REPLACE PROCEDURE test(p_table IN varchar2) IS v_sqltxt varchar2(4000); BEGIN v_sqltxt:='select count(*) from '||p_table; dbms_output.put_line(v_sqltxt); END; /
But I am unable to give the where condition dynamically. How can I do that?