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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s. syam sundar
try this
create table emp1 as select
empno,empdesig,empname,empcountry from emp
this would creat a new table named as emp1 and
u can retrive the data from this table as of emp
but constraints,indexs which u have on emp table are
created on this emp1 table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bala
try updating the values for COLUMN_ID in the
ALL_TAB_COLUMNS table..using Admin Privilege. to update
this table...
Is This Answer Correct ? | 1 Yes | 2 No |
Is sql developer case sensitive?
Explain the order of sql statement execution?
How do sql databases work?
When is the update_statistics command used?
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
Is it possible to link two groups inside a cross products after the cross products group has been created?
Explain the difference between sql and mysql.
how to enter binary numbers in sql statements? : Sql dba
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
How do you exit in sql?
what is the difference between stored procedure and packaged procedure
How would you reference column values before and after you have inserted and deleted triggers?