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.
- 3 Answers
- 6237 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
Can we insert in sql function?
How do you change a value in sql?
Can we call stored procedure in function?
Which are sql * plus commands?
Explain the the update statement in sql?
What is normalization? How many normalization forms are there?
Can we edit a view in sql?
How many sectors are in a partition?
how can we repair a mysql table? : Sql dba
how to start mysql server? : Sql dba
What does count (*) mean in sql?
What is full join?
How to write a query to show the details of a student from students table whose
What is a pdo connection?
What are the query optimization techniques?
