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.
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
How many sectors are in a partition?
What is foreign key sql?
How do I sort a table in sql?
What is difference between left and right outer join?
What is materialized view in sql?
What port does sql server use?
Is nosql relational?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What view means?
how to calculate expressions with sql statements? : Sql dba
What is union?
What is sql table?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Where can I learn sql for free?
Is left join and outer join same?