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
6905 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

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1045

What is exit statement?

1016

What is a table?

1015

what is 'mysqladmin' in mysql? : Sql dba

1025

What is application trigger?

998

Can a table contain multiple primary key’s?

1098

What is the maximum size of sqlite database?

1111

Mention what does the hierarchical profiler does?

1090

Is t sql a programming language?

1065

what happens if null values are involved in expressions? : Sql dba

1045

What is sp_helptext?

1067

Define the select into statement.

1057

How to get list of all tables from a database?

1160

How to return multiple rows from the stored procedure?

970

What is sqlexception in java?

990