Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  

---

How to create a new table by selecting rows from another table?

0 Answers  

---

How to create an oracle database?

0 Answers  

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

0 Answers   Goldman Sachs,

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

What suggestions do you have to reduce the network traffic?

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

Explain an exception?

0 Answers  

---

What are the various oracle database objects?

0 Answers  

---

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,

---