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
- 6257 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
What is sql catalog?
Where is pl sql used?
How to add a column ‘salary’ to a table employee_details?
Why do we use subquery?
What are the various levels of constraints?
Does truncate release storage space?
What are different types of keys?
What is schema in sql?
What is the benefit of foreign key?
What is a relationship and what are they?
What is the use of procedures?
Can a table contain multiple primary key’s?
Write a sql query to find the names of employees that begin with ‘a’?
Can we update views in sql?
What is the difference between stored procedure and view?
