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
- 6238 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 we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the purpose of my sql?
What is difference between nchar and nvarchar?
Differentiate pl/sql and sql?
How to assign sql query results to pl sql variables?
What are inner and outer joins examples of both?
How can a pl sql block be executed?
What are pl sql data types?
How do you respond to dementia behavior?
How to run sql commands in sql*plus?
How exception is different from error?
what are the advantages of mysql in comparison to oracle? : Sql dba
What are aggregate functions in sql?
Explain about various levels of constraint.
Which is faster view or stored procedure?
