Re: Renaming or Deleting a Column

In article <BwE9L4.GAI_at_well.sf.ca.us> mharper_at_well.sf.ca.us (Michael J. Harper) writes:
>Is there any way to change the name of a column in a table on the fly?
>Or to delete a column from a table altogether, again on the fly?
>
>I really need to change the name of a column because I need to create
>a new column with the same name as the "old" column. So, the old column
>needs either to have its name changed or to be deleted altogether.

If your new column name is the same as the old column, you can simply NULL out the old column, change the datatype and reassign values for the new column (assuming there is a datatype change). Otherwise, a simple update statement should be able to handle thetask.

-- 
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 	Alvin W. Law				Email :	alaw_at_oracle.com
 	Manufacturing Applications		        !uunet!oracle!alaw
	Oracle Corporation			Voice : (415) 506-3390