Answer Posted / orawhiz

Public database link is created for the special user group
PUBLIC.

A public database link can be used when any user in the
associated database specifies a global object name in a SQL
statement or object definition.

Explain the features of oracle?

1046

---

How do you bind variables in oracle?

981

---

How many types of database triggers exist?

1135

---

Why do we use coalesce function in oracle?

1123

---

How to write text literals in oracle?

1068

---

Explain view?

1037

---

What is the parameter mode that can be passed to a procedure?

1048

---

What is dual table oracle?

985

---

Give the various rollback segment states.

1052

---

What is Trigger in Oracle?

1173

---

How to best split csv strings in oracle 9i?

1041

---

How to create additional tablespaces for an new database?

1029

---

Explain about integrity constraint?

1125

---

What is a select query statement in oracle?

968

---

What's dateware house and what's clustor with practicle example

2175

---