Vitor,

Tá na mão!

===============================================================

Changing the data type of a column in Oracle

ALTER TABLE <table_name> MODIFY (<column_name> <new_Type>)

sample:

ALTER TABLE place 
MODIFY (
    street_name VARCHAR2(20),
    county      VARCHAR2(20),
    city        VARCHAR2(20)
    )

https://stackoverflow.com/questions/10321775/changing-the-data-type-of-a-column-in-oracle

===============================================================

Oracle: How to change column data type from VARCHAR to NUMBER without losing data

https://stackoverflow.com/questions/59853182/oracle-how-to-change-column-data-type-from-varchar-to-number-without-losing-dat

===============================================================

Oracle ALTER TABLE MODIFY Column

Summary: in this tutorial, you will learn how to use the Oracle ALTER TABLE MODIFY column statement to change the definition of existing columns.

To change the definition of a column in a table, you use the ALTER TABLE MODIFY column syntax as follows:

ALTER TABLE table_name 
MODIFY column_name action;

https://www.oracletutorial.com/oracle-basics/oracle-alter-table-modify-column/

===============================================================

[]'s,

Fabio I.