try updating the values for COLUMN_ID in the ALL_TAB

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 / bala

3 Answers
7022 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How do you modify a trigger?

984

What is embedded sql in db2?

1061

Why do we use subquery?

1080

What is the purpose of primary key?

1073

What is a scalar value in sql?

1126

How many developers work on postgresql?

1042

what is a join? : Sql dba

1086

What are commit, rollback, and savepoint?

1049

What are the limitations of sql express?

1123

Can we call stored procedure in function?

1004

What is foreign key in sql with example?

979

What is the use of count (*) in sql?

1119

explain the difference between delete , truncate and drop commands? : Sql dba

1147

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1053

Write a query to display the current date in sql?

1078