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

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037

Is nosql relational?

926

What is cursor explain with example?

964

Name three sql operations that perform a sort.

987

What is the purpose of normalization?

1032

Explain what is a subquery ?

1166

What is a parameter query?

1058

What are triggers and its uses?

1032

Is primary key always clustered index?

993

What is a .db file?

960

explain the difference between bool, tinyint and bit. : Sql dba

976

What is a constraint?

997

What is union and union all keyword in sql?

1017

Mention what plvcmt and plvrb does in pl/sql?

1113

What is the difference between a subquery and a join?

1073