Change the Sort order of the columns in the table structure.

[islandfong]

Hi all,

I have a table t which contains 2 columns C1 and C2. Now I want to add one more column C3. I want C3 to be between C1 and C2. So the expected sequence is C1, C3, C2. Is there any way to achieve this in Oracle? I am using Oracle 10g.

[rushdishams]

No mate, there is no way of doing this as the basic or RDBMS is- "the order of column is of no importance." however, you can only create a new table by dropping the current table according to order of columns of your demand.

Cheers!

[debasisdas]

Sorry dear that is not possible in Oracle using any version.
Because data retrival is independent of data stogare.
if u want to retrive data in any other sequence than actual srogare u can, there is no restriction.
so specify the column name in the order u want independent of table structure(actua l column order in the table)

[contactsanjaykumar]

It become possible, if u drop the table and recreate the table according to the order of colunm as required.