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
- 7019 Views
- I also Faced
- E-Mail Answers
Answer Posted / s. syam sundar
try this
create table emp1 as select
empno,empdesig,empname,empcountry from emp
this would creat a new table named as emp1 and
u can retrive the data from this table as of emp
but constraints,indexs which u have on emp table are
created on this emp1 table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many columns should be in an index?
What is primary key and unique key?
How do I truncate a word?
What is a left join?
What is relationship? How many types of relationship are there?
How to raise user-defined exception with custom sqlerrm ?
What are different clauses used in sql?
What is an example of translating a date into julian format?
What is pl/sql table? Why is it used?
What is a system versioned table?
What is meant by <> in sql?
what is denormalization. : Sql dba
Can you rollback after commit?
Which normal form is best?
What is a primary key example?
