I have table called packagelines contains 3220 records
SQL> desc packagelines;
Name Null? Type
----------------------------------------- -------- --------------
CORP NOT NULL NUMBER(2)
PKG NOT NULL CHAR(2)
PKGSTOP NOT NULL CHAR(6)
LINE NOT NULL CHAR(4)
RCODE NOT NULL CHAR(2)
Now i want to reduce the size of a column LINE CHAR(4) to CHAR(2).How can i do it.
only two character data is present in the column LINE