Answer Posted / naweed ahmad

UPDATE TABLE NAME SET COLUMN NAME=NEW VALUE
WHERE CONDITION;
--(WHERE CONDITION IS OPTIONAL)

Is oracle a relational database?

916

---

How to run create database statement again?

1157

---

How to use values from other tables in update statements using oracle?

1080

---

What is the data pump export utility?

1081

---

Whats the benefit of dbms_stats over analyze?

2003

---

What is a lookup table in oracle?

973

---

State the various uses of dbcc command?

1060

---

How to rollback the current transaction in oracle?

1055

---

How to pass parameters to procedures?

1034

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2498

---

Why is oracle used?

938

---

How to insert multiple rows with one insert statement in oracle?

1087

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

---

Can a formula column be obtained through a select statement ?

2327

---

how to clone 9i Database on to 10g Database.

2340

---