SQL>  desc user_tab_partitions
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 TABLE_NAME                                VARCHAR2(30)
 COMPOSITE                                 VARCHAR2(3)
 PARTITION_NAME                            VARCHAR2(30)
 SUBPARTITION_COUNT                        NUMBER

 HIGH_VALUE                                LONG
 HIGH_VALUE_LENGTH                         NUMBER

 PARTITION_POSITION                        NUMBER
 TABLESPACE_NAME                           VARCHAR2(30)
 PCT_FREE                                  NUMBER
 PCT_USED                                  NUMBER
 INI_TRANS                                 NUMBER
 MAX_TRANS                                 NUMBER
 INITIAL_EXTENT                            NUMBER
 NEXT_EXTENT                               NUMBER
 MIN_EXTENT                                NUMBER
 MAX_EXTENT                                NUMBER
 PCT_INCREASE                              NUMBER
 FREELISTS                                 NUMBER
 FREELIST_GROUPS                           NUMBER
 LOGGING                                   VARCHAR2(7)
 COMPRESSION                               VARCHAR2(8)
 NUM_ROWS                                  NUMBER
 BLOCKS                                    NUMBER
 EMPTY_BLOCKS                              NUMBER
 AVG_SPACE                                 NUMBER
 CHAIN_CNT                                 NUMBER
 AVG_ROW_LEN                               NUMBER
 SAMPLE_SIZE                               NUMBER
 LAST_ANALYZED                             DATE
 BUFFER_POOL                               VARCHAR2(7)
 GLOBAL_STATS                              VARCHAR2(3)
 USER_STATS                                VARCHAR2(3)

I have a range date partition table month wise which i want to truncate the partition and load for each month data i get from source.

How can i get the partion name based on data value.

What is the syntax of truncate partition for.

ALTER TABLE table_name TRUNCATE PARTITION FOR(partitioning_column_value);

alter table range_sales
truncate partition for(date '2000-02-15')

In the above example can i write month as well. where can i find the documented for the above syntax. the above example is by date wise but i want to do it month wise.

my question is that the above syntax only takes date as a value or it can take something else as well