SQL & PL/SQL

Hi All,

I am using 10g.

my requirement i will exec a procedure which will have parameter, the parameter will be table which will be sent in run time.

In output i need count of table, display all the data, display the table datatype


This is the procedure which i have wrote. please suggest the change i have to do.

CREATE OR REPLACE PROCEDURE TEST_PROC_123(input varchar2) is
begin

DBMS_OUTPUT.PUT_LINE('select count(*) from' || ' ' || input||';');
DBMS_OUTPUT.PUT_LINE('select * from' || ' ' || input||';');
DBMS_OUTPUT.PUT_LINE('select count(*) from' || ' ' || input||';');
end;

Thanks in advance.

Edited by: user10285804 on Apr 15, 2011 10:11 PM

Edited by: user10285804 on Apr 15, 2011 10:39 PM

Edited by: user10285804 on Apr 15, 2011 10:43 PM