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
- 5786 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
Why is %isopen always false for an implicit cursor?
What is trigger and how to use it in sql?
What are the differences between implicit and explicit cursors?
What is the maximum number of columns in sql table?
Which join condition can be specified using on clause?
Is coalesce faster than isnull?
How would you reference column values before and after you have inserted and deleted triggers?
What is synonyms?
Describe sql comments?
What is trigger types of trigger?
Can we join 3 tables in sql?
Explain the insert into statements in sql?
Write a query to display the current date in sql?
Explain the components of sql?
What is varray in pl sql?
