How to Create Table Name That Contains Last Month in Suffix
declare
  l_cmd clob;
begin
  l_cmd := 'create table abc_'|| to_char(add_months(SYSDATE,-1), 'MONDD') || ' (c1 number)';
  execute immediate l_cmd;
end;
/

SQL&gt; select table_name from user_tables where table_name like 'ABC%';

TABLE_NAME
----------
ABC_JAN13


SQL&gt; desc abc_jan13
 Name  Null?    Type
 ----- -------- -------
 C1             NUMBER