Answer Posted / guest

It is a constraint used to avoid duplication of values
within the row of a specified column or set of columns in a
table. It can also allow null values

How to display row numbers with the records?

1024

---

What is the difference between substr & instr functions?

1119

---

Is primary key indexed by default in oracle?

928

---

what is the difference between data migration and production migration.

2274

---

How to create a table interactively?

996

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3152

---

Can I create users through internet explorer in oracle 10g?

1018

---

Explain the importance of .pll extension in oracle?

952

---

Explain self joins in oracle?

949

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2130

---

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 ?

2412

---

What is meant by joins? List out the types of joins.

957

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4114

---

How to create an oracle database manually?

1018

---

Why do we use coalesce function in oracle?

1050

---