Input table name learning for stored procedures in Oracle

Input table name learning for stored procedures in Oracle
Input table name in Oracle stored procedure: 1. dynamically clear data of the table

Create or replace procedure p_deletetable (I _tableName in varchar2) as -- Define the SQL statement dynamic_drop_ SQL varchar2 (500) for storing variables; begin dynamic_drop_ SQL: = 'delete from' | I _tableName; -- execute the dynamic SQL statement execute immediate dynamic_drop_ SQL; commit; end p_deletetable;

Ii. Create a table in oracle with the dynamic Table Name:

Begin execute immediate 'create table a_bak _ '| to_char (sysdate, 'yyyymmdd') | 'as select * from a'; end;