oracle sql 如何把数据库VARCHAR2() 查出再按number类型排序

oracle中VARCHAR2() 转换成number类型后再用sort排序。 INSERT INTO TABLE_Y (COLUMN_Y) --Column Y is a NUMBER type SELECT TO_NUMBER(COLUMN_X) --Column X is a VARCHAR type FROM TABLE_X