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.
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
What is left join in postgresql?
What does joining a thread mean?
What is lookup table in sql?
What are the different types of tables in sql?
How to get list of all tables from a database?
What is java sql drivermanager?
Why procedure is used in sql?
what are all types of user defined functions? : Sql dba
When is a declare statement required?
What is the difference between unique and primary key constraints?
Can we use update in sql function?
Is it possible to pass parameters to triggers?
What is the purpose of the partition table?
How to use transactions efficiently : transact sql
How do I create a sql database?