How can we add columns using alter class to a table and that column should not be on the last, and it should be at where or the place which we want, must be on the middle or anywhere like that
Printable View
How can we add columns using alter class to a table and that column should not be on the last, and it should be at where or the place which we want, must be on the middle or anywhere like that
Try the post of Bhaski in the [URL="http://www.geekinterview.com/talk/3243-inserting-column-in-existing-table.html"]link[/URL]
Note :But ur user must have proper privileges
actually no need to rearrange these columns
if at all u want to do this to my known knowledge this can be done in two steps
step1:- alter table <oldtablename> add
(<columndefinition>);
step2:- create table <newtablename>
as
select <column names as u required in the sequence> from <oldtablename>;