CODEWITHSUNDEEP
sqloracle-databaseddl
LH44
LH44

Reputation: 23

Alter statement to change datatype of a column form NUMBER(4 ) to NUMBER in Oracle

what is the ALTER Statement to change datatype of a column form NUMBER(4) to NUMBER in oracle

Upvotes: 0

Views: 57

Answers (1)

Viktor Török
Viktor Török

Reputation: 1319

Try this SQL statement:

alter table yourtable modify yourcolumn number;

Upvotes: 3

Related Questions