File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
SQL question : changing the string size of a column
Joined: Nov 18, 2002
Jun 11, 2003 14:20:00
I have a table that is already created and filled with data. One of the column is a VARCHAR(20)
and I'd like to change it now to something bigger VARCHAR(300).
What is the SQL command to do it ??
Sam<p>"Life is difficult"<br /> -Scott Peck-</p>
Joined: May 22, 2002
Jun 11, 2003 16:16:00
This is how it's done in Oracle:
alter table your_table modify the_column varchar2(300);
Normal is in the eye of the beholder
I agree. Here's the link:
subject: SQL question : changing the string size of a column
Inserting values from textbox into database
Get only date in a select statement
Problem in reading a multilengual XML file into database
SQL SUM function
ORA-00972: identifier is too long at select statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015