Answer Posted / arshi

trigger is autorun query. for example if you perform some
operation that time some operation(insert,delete) shuld be
execute automatically that time you have to use trigger

How to write a query with a right outer join in oracle?

1222

---

What is Redo Log Buffer in Oracle?

1278

---

How to start your 10g xe server?

1087

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2143

---

How to upsert (update or insert into a table)?

1042

---

What are the differences between lov and list item?

1142

---

What is an oracle function?

1241

---

Can sub procedure/function be called recursively?

1049

---

What is oracle server autotrace in oracle?

1220

---

what are archived logs?

2260

---

What is oracle join syntax?

1061

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2312

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

---

How to drop an index in oracle?

1120

---

What is ASM (Automatic Storage Management) in Oracle?

1244

---