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
- 6852 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 use ddl statements in stored procedure?
What are % type and % rowtype?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is mutating table error?
Explain constraints in sql?
How do I run a pl sql procedure in sql developer?
What is blind sql injection?
How to connect a sql*plus session to an oracle server?
How do I view a sql trace file?
Is it possible to update views?
Mention what is the plv (pl/vision) package offers?
What are all the common sql functions?
How to rename a table?
What are different types of sql commands?
How do you delete duplicates in sql query using rowid?
