FOR Loop throws ORA-00933
BEGIN
FOR part IN ( select PARTITION_NAME from all_tab_partitions where table_name = 'TEMP123' )
LOOP
INSERT into TEMP234 SELECT * from TEMP123 PARTITION ( part.PARTITION_NAME ) ;
END LOOP;
END;
What is wrong here?
Thanks.
Edited by: Abhishek_H on Jun 2, 2013 11:29 PM