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
- 5818 Views
- I also Faced
- E-Mail Answers
Answer Posted / jyothi
there is only one way to to re-arrange the table
that is views...
create view <view-name>as select <fields> from <tablename>
.........
for example..
create view vw as select empno,empdesig,empname,empcountry
from <tablename>...
(u can get message that is view created)
just display the data using viewname(vw)..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we join tables without foreign key?
What are properties of the transaction?
How do you write a subquery?
What is the use of sqlerrd 3?
What are the advantages of indexing?
Explain constraints in sql?
explain mysql aggregate functions. : Sql dba
What is difference between stored procedures and application procedures?
Can we create foreign key without primary key?
What are the main features of cursor?
how many tables will create when we create table, what are they? : Sql dba
what is oracle database ? : Sql dba
Which command is used to delete a package?
What is sql architecture?
What is sql dialect?
