How to Create Table Name That Contains Last Month in Suffix I want to create a table with the last month's name as part of the table name.
If the current month is February then I would want the table name to look like this: table_name_jan18

The statement I have so far looks like this:

create table abc_'||'trunc(SYSDATE,'mm')-1';
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