E Correct.
create table a_test
(c1 VARCHAR2(10),
c2 NUMBER(10));
insert into a_test values ('123', 123);
select * from a_test;
commit;
alter table a_test modify c1 VARCHAR2(5);
alter table a_test modify c2 NUMBER(12,2);
desc a_test;
if
alter table a_test modify c1 VARCHAR2(2);
ORA-01441: cannot decrease column length because some value is too big
alter table a_test modify c2 NUMBER(15,2); - worked
BUT
alter table a_test modify c2 NUMBER(15); - don't worked
ORA-01440: column to be modified must be empty to decrease precision or scale
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ayman_Khalifa
6 months agozzz02
3 months, 3 weeks agoyaya32
11 months, 4 weeks agoMcromeo
1 year, 1 month agoWingL
1 year, 6 months agoWingL
1 year, 6 months agozouve
1 year, 6 months agoDarnun
1 year, 9 months agojfc1
1 year, 11 months ago