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

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 Received on Wed Feb 25 1998 - 00:00:00 CST