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;
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;