Answer Posted / ramesh

create table emp(sal number(5,2);

How to create a stored program unit?

578

---

How to use existing values in update statements using oracle?

545

---

What is materialized view in Oracle?

630

---

What is the difference between $oracle_base and $oracle_home?

581

---

What is a static data dictionary in oracle?

566

---

---

How do we create privileges in oracle?

584

---

What is the quickest way to export a table to a flat file?

568

---

What is tns entry?

621

---

What is Undo Management Advisor in Oracle?

609

---

What is the difference between sharding and replication?

475

---

What is pragma autonomous transaction in oracle?

516

---

Explain a synonym?

600

---

please explain.. DB architecture ...

1557

---

Where do we use decode and case statements?

557

---

What is snapshot is too old? Give and example for better understand.

1097

---