Answer Posted / guest

select * from tablename
where(col1=>10)update col2=234;

What is the difference between view and materialized view in Oracle?

1156

---

Can we insert data in view oracle?

1042

---

What is bulk load in oracle?

1070

---

How to convert characters to numbers in oracle?

1065

---

What are the ways tablespaces can be managed and how do they differ?

2368

---

how may join possible between (requisition with purchase order)

2252

---

What is recovery manager(rman) backup in Oracle?

1185

---

Explain mutating triggers.

1034

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

---

How to define a sub function?

1136

---

How to change user password in oracle?

1029

---

Can sub procedure/function be called recursively?

1006

---

Why does for update in oracle 8 cause an ora-01002 error?

1003

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1953

---

What to do if dba lost the system password?

1172

---