Stored procedures in Oracle incoming table name learning

Stored procedure incoming table name in Oracle:

First, the data of the table is purged dynamically

Create or Replace procedure p_deletetable (I_tablename in varchar2) as--Define variables to hold dynamic SQL statements Dynamic_drop_sql VARCHAR2 (500); Begin Dynamic_drop_sql: = ' DELETE from ' | |  I_tablename;--Execute dynamic SQL statement execute immediate dynamic_drop_sql; Commit End p_deletetable; Ii. Oracle CREATE TABLE, dynamic table name: begin

Execute immediate ' CREATE table A_bak_ ' | | To_char (sysdate, ' YYYYMMDD ') | |  ' AS SELECT * from a ';

End

Stored procedures in Oracle incoming table name learning