RE: adding col in between....

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 19 Jul 2005 11:15:54 +0200
Message-Id: <20050719091553.CBFA41D1BFC@turing.freelists.org>

... and the counter question is: why would you ever want to do this? this is highly un-relational, because column ordering is supposed to be meaningless.
well, let me answer your question anyway: in Oracle, there is no direct way to accomplish this.
check out the DBMS_REDEFINITION package -- that will do the job for you, if you insist :-)

cheers,

Lex.

---

Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html> http://www.naturaljoin.nl/events/seminars.html

---

 

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary
Sent: Tuesday, July 19, 2005 07:39
To: oracle-l_at_freelists.org
Subject: adding col in between....

hi all,  

Is it possible to add a new column in the between of table. For ex. Say there is a table as  

col position              col name
1                               ID
2                               Name
3                               Address
 

I have to add a col. after NAME col and before ADDRESS col. Is it possible ? how ?  

TIA

-- 
Thanks & Regards,
T. Onkar Nath
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
 





--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 19 2005 - 04:17:49 CDT