Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

add ( test-col2 char(1O))

10.02      How to change the data type?

The data type which has been already created as char(2), and  need to be changed as number with width and precision,

MODIFY the column test-col2 char (1O) as Test-col2 number (16, 2)

Through obJect Browser

Through sql command

Window

→ Tables

alter table testtable