Answer Posted / ananthram

Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.

Explain the blob datatype?

1069

---

Whether any commands are used for months calculation? If so, what are they?

1093

---

Where are the settings stored for each instance in oracle?

1100

---

How to insert a new row into a table in oracle?

1154

---

What is BBED in Oracle?

1148

---

How to use attributes of the implicit cursor in oracle?

999

---

How to shutdown your 10g xe server from command line?

1081

---

How do I limit the number of rows returned by an oracle query after ordering?

1160

---

How to convert raw data type into text in oracle? Explain

989

---

Why packages are used in oracle?

1064

---

What are the oracle built-in data types?

1054

---

Is a rollback possible to any savepoint?

1092

---

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

1062

---

How to create a new view in oracle?

1069

---

can u plz provide me oca sql dumps please i need them

1942

---