CODEWITHSUNDEEP
sqloracle-databaseoracle11galter
vinr
vinr

Reputation: 25

Alter a table column to 4000Byte - Oracle 11g

I need to give a script to DBA to alter the length of a column to 4000 Byte and not 4000 Char.

Since I cannot execute the script on DB due to inadequate permission and conflicting answers on Web, I am not sure of the script.

Please let me know if this one is correct:

ALTER TABLE AAA.BBB_CCC MODIFY(VALUE VARCHAR2(4000));

I think :

ALTER TABLE AAA.BBB_CCC MODIFY(VALUE VARCHAR2(4000 CHAR));

would create column size of 4000 Char

Upvotes: 0

Views: 9270

Answers (2)

Shariar Imtiaz
Shariar Imtiaz

Reputation: 493

Use below command to modify column. 

Create table abc(
id varchar2(400)
);

============
Table created.

alter table abc modify id varchar2(4000 byte);
============
Table altered.

Upvotes: 1

Sentinel
Sentinel

Reputation: 6449

Neither is correct, try this:

ALTER TABLE AAA.BBB_CCC MODIFY DDD varchar2(4000 BYTE);

Upvotes: 1

Related Questions