Home » SQL & PL/SQL » SQL & PL/SQL » something about column
something about column [message #91] Fri, 11 January 2002 23:11 Go to next message
diana365
Messages: 4
Registered: January 2002
Junior Member
can column be sorted?..i've created a table,but then i miss a column.i add it into the table..ok..but i want it to be the 2nd column..instead the last one.can we do that?
Re: something about column [message #92 is a reply to message #91] Sat, 12 January 2002 10:11 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
no way, you have to drop table and recreate it.
if you have already data in it.

1)alter table tab1 rename to tab2;

2) create new table tab1 with proper order of columns

create table tab1 as select col1,col4,col2,col3 from tab2;

so that 4th column moves to second position

3) drop table tab2;
Previous Topic: non restrictive ref cursor
Next Topic: Re: 8.1.5 data encryption
Goto Forum:
  


Current Time: Tue Mar 31 11:28:12 CDT 2020