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
- 6732 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 are sql queries used for?
What is the difference between pl and sql?
Can we use update in sql function?
How delete a row in sql?
How do you use a while loop in pl sql?
How to combine two stored procedures in sql?
tell me about various levels of constraint. : Sql dba
What is pl sql in oracle?
How many sql commands are there?
What are all the different normalization?
Explain lock escalation? : Transact sql
What is the most restrictive isolation level? : Transact sql
What is the difference among union, minus and intersect?
How would you convert date into julian date format?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
