SQL help

jon1981 · 2008-07-09 11:15:16

hi, I currently have a table, call it "myTable" that has a field "myField" defined as varchar2(2 bytes). how do i change this to 5 bytes? i never work with databases but im trying to do something quickly to test something. im using toad cheers edit: its an oracle DB

09-07-2008 12:15PM

#1

jon1981

Registered Users, Registered Users 2 Posts: 4,349 ✭✭✭

Join Date: January 2007

Posts: 3860

hi,

I currently have a table, call it "myTable" that has a field "myField" defined as varchar2(2 bytes).

how do i change this to 5 bytes? i never work with databases but im trying to do something quickly to test something. im using toad

cheers

edit: its an oracle DB

0

Comments

#2 09-07-2008 12:24PM

forbairt

Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭

Join Date: September 2004

Posts: 3389

would this do the trick for you ?

ALTER TABLE
myTable
MODIFY
(
myField varchar2(5)
)
;

0
#3 09-07-2008 12:26PM

jon1981

Registered Users, Registered Users 2 Posts: 4,349 ✭✭✭

Join Date: January 2007

Posts: 3860

forbairt wrote: »

would this do the trick for you ?

cheers i was using change instead of modify...that worked

0