用于将文本格式化为数字的SQLplus脚本

I am selecting rows from a table, but some of the columns are a text type, but they always have numeric data in them. How can I format them as numbers?I am selecting rows from a table, but some of t