BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE ca.T_GROUP_TEMP AS
select substr('||TO_PRODUCT_ID||',0,10)||substr(GROUP_ID,10,length(GROUP_ID)) as GROUP_ID
,FATHER_GROUP_ID,GROUP_NAME,GROUP_DESC,GROUP_CODE,OWN_MODE,'||TO_PRODUCT_ID||' as OWN_ID
from ca.T_GROUP
WHERE OWN_ID='||PRODUCT_ID;
END;
