change structure of a table

[goilaswati]

is there any way one can change the structure of a table after it is created. say for ex. change the name of a field or delete a field or change the type of a field.
please tell the syntax.

 

[bandisr]

hi,
look alter table syntax. you can add/delete or modify column definition.
hth,
sreekanth Sreekanth Reddy Bandi,
Persistent Systems Pvt. Ltd.,
(

http://www.persistent.co.in)

 

[Scunningham99]

alter table table1 drop column col1 --to drop column called col1. Works in 9i not sure in 8i!

--to modify field

alter table table1
modify (col1 varchar2); to change to varchar2. Note Make sure values are null in coluumn before you update it. ie --> update table1 set col1 = null

sy Sy UK