OraFAQ Forum: SQL & PL/SQL » alter table col

Home » SQL & PL/SQL » SQL & PL/SQL » alter table col

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter table col [message #9358]

Wed, 05 November 2003 22:37

lok
Messages: 4
Registered: November 2003

Junior Member

i have a table
Name Null? Type
------------------------------- -------- ----
STATION NOT NULL VARCHAR2(20)
TWO_L VARCHAR2(2)
THREE_L NOT NULL VARCHAR2(2)
i want to alter the col Three_l not null varcha2(3),

please advice me

thanks

Report message to a moderator

Re: alter table col [message #9359 is a reply to message #9358]

Thu, 06 November 2003 00:02

Rajarshi Dasgupta
Messages: 52
Registered: October 2001

Member

execute the following command at SQL prompt...

Alter Table

Modify THREE_L NOT NULL VARCHAR2(3));

Report message to a moderator

Re: alter table col [message #9362 is a reply to message #9358]

Thu, 06 November 2003 00:59

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Some additional info. The command by Rajarshi is correct but beware of the following.

Make sure that the column does not contain NULLs, or you'll hit the ORA-02296 (Null values found).
If you insist the constraint to be created you can add the NOVALIDATE keyword. This will enable the constraint without validation.

The length of a column cannot be decreased if the column contains values: It must be set to NULL in all records before you can decrease the length. Increasing is no problem.

MHE

Report message to a moderator