SQL & PL/SQL

Hi All,

I have a requirement, where i need to insert the data of one partition of a table into an another partition using the Merge statement. could it be possible?

here is the structure of my table:

desc cl_acct

Name                            Null               Type        

---------------------           --------             ------------

EODS_CL_ID            NOT NULL      NUMBER(38)  

EODS_ACCT_ID       NOT NULL      NUMBER(38)  

PRTT_CDE                NOT NULL      VARCHAR2(10)

BCH_DTE                  NOT NULL      DATE        

DATA_GRP_CDE      NOT NULL      VARCHAR2(10)

the partition code(prtt_cde) will always have value such as CGA_0 & CGA_1. I tried a lot but unable to find the syntax which is working.