Try this: alter table users modify username varchar2(50);
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:43 AM To: CF-Talk Subject: Alter Column syntax in Oracle? 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
