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)..

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

Answer / bala

try updating the values for COLUMN_ID in the
ALL_TAB_COLUMNS table..using Admin Privilege. to update
this table...

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

---

What are all the different normalization?

0 Answers  

---

what is inline view?

15 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

What are sql injection vulnerabilities?

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

What is java sql package?

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---