This should help: http://info-it.umsystem.edu/oradocs/doc/server/doc/SQL73/ch4a.htm#toc064
At 12:42 AM 7/12/02, you wrote: >I want to change a varchar2 field from 10 characters to 50. I can't >seem to get the syntax right. I'm not all that familiar with Oracle. >What am I doing wrong here? This and all the variations I can dream up >aren't working. > >ALTER TABLE users ALTER COLUMN ( UserName VARCHAR2(50) ); > >Any insight would be really appreciated! > >--Matt Robertson-- >MSB Designs, Inc. >http://mysecretbase.com > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
