How to change the data type of a column , retaining the data it already has? Use the below script: DECLARE TYPE t is table of <tablename>.<columnname>%type index by pls_integer; temp t; BEGIN select <columnname> BULK COLLECT into tem… more »