-- Step 1: Add a new column with the required precision

-- Step 2: Copy data from the old column to the new column

-- Step 3: Drop the old column (only after verifying the data)

-- Step 4: Rename the new column to match the original column name

This worked in ORACLESQL DEVELOPER