title: Range partition on CHAR/VARCHAR2 data type for every month
body: <p>We have a table where we are trying to create a RANGE partition on CHAR data type for each month as mentioned below. But we are getting errors.The ACC_DATE value will be like '202010'. Can this be done in ORACLE? because the same can be done in DB2. But we have to implement it in ORACLE.</p>
  <p>Error we are getting:</p>
  <blockquote>
  <p>ORA-14751: Invalid data type for partitioning column of an interval partitioned table</p>
  </blockquote>
  <pre><code>CREATE TABLE T_ACCOUNT_PARTITION
  (
      V_ACCOUNT_NUM  VARCHAR2(100 CHAR),
      V_ACCOUNT_NAME VARCHAR2(200 CHAR),
      ACC_DATE CHAR(6)
  )
  PARTITION BY RANGE (ACC_DATE) INTERVAL (NUMTOYMINTERVAL(1, 'MONTH'))
  (PARTITION P_MAY2021 VALUES LESS THAN (202105));
  </code></pre>