Changing the Precision of a Numeric Column
The following ALTER TABLE statement changes the precision of the emp.empno column to 5:
SQL> CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
2 ENAME VARCHAR2(10),
3 JOB VARCHAR2(9),
4 SAL NUMBER(7, 2),
5 DEPTNO NUMBER(2));
Table created.
SQL>
SQL> ALTER TABLE emp
2 MODIFY empno NUMBER(5);
Table altered.
SQL>
SQL> desc emp
Name Null? Type
----------------------------------------- -------- ----------------
EMPNO NOT NULL NUMBER(5)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
SAL NUMBER(7,2)
DEPTNO NUMBER(2)
SQL>
You can only decrease the precision of a numeric column if table is empty or the column contains null values.
Home »
Oracle »
Table »
Oracle »
Table »
Column:
- Adding a Column
- Adding a Virtual Column
- Changing the Size of a Column
- Changing the Precision of a Numeric Column
- Changing the Data Type of a Column
- Changing the Default Value of a Column
- Dropping a Column
Related: