RE: adding col in between....
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <onkarnath.tiwary@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Jul 2005 11:15:54 +0200
... 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Onkar N Tiwary
Sent: Tuesday, July 19, 2005 07:39
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
