|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 22nd, 2005, 07:47 PM
|
|||
|
|||
|
Alter Table
I'm trying to make a column longer (without making a new column and copying each entry) so I tried:
Code:
alter table tablename alter column email varchar(150); But I get an error when I try that. Is that not the right syntax?
|
|
#2
September 23rd, 2005, 03:09 AM
|
||||
|
||||
|
Sorry, but RTFM
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#4
September 23rd, 2005, 10:45 AM
|
||||
|
||||
|
|
#5
September 23rd, 2005, 11:08 AM
|
|||
|
|||
|
Haha I like it. I'm going to start using that one in my labs. Thanks for the help.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Alter Table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
