How to Modify variable length

[shailaja siddappa]

Hi,
i need to modify the variable length from 2 to 3.
how to do that, without loosing the table data.


grant_package NUMBER(2,0) NOT NULL,
work_code NUMBER(3,0) NOT NULL,


thanks in advance,
shailaja

[John Bengler]

Hi Shialaja,

if you are speaking of the length of columns in the DB the solution is the command

"alter table modify (column_name datatype)".

With an alter table command you won't loose data (except if you drop columns, of course).

You can find details of the alter table statement in the Oracle documentation,e.g. here:

Alter Table


John