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


______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.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

Reply via email to