Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6728 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
What is PL/SQL Records?
What are the different sql languages?
How does stored procedure reduce network traffic?
What are all the different normalizations?
What is the use of non clustered index?
How to display the records between two range in Oracle SQL Plus?
What are the types of join and explain each?
What is a unique constraint?
How do I remove duplicates in two columns?
What is difference between primary and secondary key?
Does a primary key have to be a number?
give the syntax of grant and revoke commands? : Sql dba
Why having clause is used in sql?
How is data stored on a disk?
How do I upgrade sql?
