Re: How do DBA products manage to insert a column in a table ??

Hi Joe,

Do you think that they rename the table, add the column at the end, create a view in the desired order and give it the name of the original table :-)

Regards

Jerry

joseph_testa_at_aep.com wrote:
>
> To add a new column is no biggie, alter table <tablename> add column_name
> column_type
>
> now oracle's stand on adding a column to the middle is that the order of
> columns in a table makes no difference except in the case of (raw) long
> datatype where you want it at the end.
>
> Adding a table to a column is a new one on me.
>
> To drop a column is alot harder, but I've written a package that will do it,
> you can find it on www.oracle-dba.com
>
> joe
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
 

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group