Hi Experts,
I have created a table with 4 columns
CREATE TABLE Temp
(
col1 VARCHAR2(40),
col2 VARCHAR2(40),
col3 VARCHAR2(11),
col4 VARCHAR2(11),
);
This table is list-partitioned based on the value of column col4, therefore a partition contains all rows loaded during an interval of six hours, resulting in 4 partitions being created per day. The string representing the value of the partition key (col4) has the following format:
YYYYMMDD_XX
Where
YYYY = Year, MM = Month, DD = Day and XX is the number of the 6-hour interval (01, 02, 03, 04).
Now how can I extract the 'XX' value from 'col4' column while creating list partition?