Answer Posted / shalini gupta

we can create a unique index as well as primary key
constrains to restrict dulpicate record. unique key allows
one null but primary key constrains does not allow null.

How to convert numbers to characters in oracle?

582

---

if you ctreate table identity

1841

---

How to assign a tablespace to a users in oracle?

585

---

How to delete multiple rows from a table in oracle?

554

---

Can you create a synonym without having a table?

544

---

---

How to start your 10g xe server?

585

---

Write a syntax for update query in oracle?

610

---

How to do clean up if create database failed?

566

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

543

---

How to rename an index in oracle?

613

---

What is parameterized cursor in oracle?

569

---

How to run create database statement?

567

---

Explain parameter file in oracle.

572

---

Differentiate between pre-select and pre-query?

612

---

Explain self joins in oracle?

552

---