There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

What is tns service name?

0 Answers  

---

Why do we use coalesce function in oracle?

0 Answers  

---

How to define an anonymous block?

0 Answers  

---

What are the different types of partitions in oracle?

0 Answers  

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

Are truncate and delete commands same? If so why?

0 Answers  

---

What is an oracle cursor variable?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

How view is different from a table?

0 Answers  

---

What is an oracle wallet?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---