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
- 7021 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 insert delete data in view?
What do you mean by query optimization?
what are tables and fields? : Sql dba
What are the dml statements?
what is the difference between a web-garden and a web-farm? : Sql dba
what is try_catch block in procedure
How many types of keys are there in sql?
Which language is used in sql?
What is the use of pl/sql table?
Can we create foreign key without primary key?
What is the difference between unique and primary key constraints?
What version is sql?
what does it mean to have quoted_identifier on? : Sql dba
what are the differences between binary and varbinary? : Sql dba
Is sql easier than java?
