Let us suppose we have a table with structure in order empno empname empdes

Let us suppose we have a table with structure in order

empno
empname
empdesig
empcountry

and now i want to re-organize the columns of this table to

empno
empdesig
empname
empcountry

how can i do this with queries ?

assume that table contains the data.

Question Posted / pk

3 Answers
6230 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Let us suppose we have a table with structure in order empno empname empdesig empcountry an..

Answer / jyothi

there is only one way to to re-arrange the table
that is views...

create view <view-name>as select <fields> from <tablename>
.........
for example..
create view vw as select empno,empdesig,empname,empcountry
from <tablename>...
(u can get message that is view created)
just display the data using viewname(vw)..

Is This Answer Correct ?

2 Yes

0 No

Let us suppose we have a table with structure in order empno empname empdesig empcountry an..

Answer / s. syam sundar

try this

create table emp1 as select
empno,empdesig,empname,empcountry from emp

this would creat a new table named as emp1 and
u can retrive the data from this table as of emp
but constraints,indexs which u have on emp table are
created on this emp1 table

Is This Answer Correct ?

0 Yes

0 No

Let us suppose we have a table with structure in order empno empname empdesig empcountry an..

Answer / bala

try updating the values for COLUMN_ID in the
ALL_TAB_COLUMNS table..using Admin Privilege. to update
this table...

Is This Answer Correct ?

1 Yes

2 No

Post New Answer