Monday, 16 January 2017

In a PL/SQL procedure, how do i pass a table name as a parameter?

CREATE OR REPLACE PROCEDURE KAU (T_NAME VARCHAR2)
AS
BEGIN

EXECUTE IMMEDIATE 'CREATE TABLE '||T_NAME||'(A NUMBER,B VARCHAR2(20))';-----------------------------create table


--EXECUTE IMMEDIATE 'INSERT INTO '|| t_name ||' VALUES (1,"amol")';---------insert into table



--EXECUTE IMMEDIATE 'DROP TABLE '||T_NAME||' ';-------drop table

END;
/



--------to execute


begin
kau('emp');
end;