Answer Posted / naweed ahmad

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

What are data pump export and import modes?

1047

---

How to use "for" statements in oracle?

1059

---

What is not equal to in oracle?

980

---

What is the data type of dual table?

976

---

What is the usage of synonyms?

1116

---

Is there a combination of "like" and "in" in sql?

1033

---

How to drop an existing table in oracle?

1046

---

How to apply filtering criteria at group level in oracle?

1024

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2261

---

What happens if you lost a data file?

1026

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1363

---

What are the tools for Oracle ?

1040

---

What are the different types of record groups in oracle? Explain each of them

1006

---

What is the difference between translate and replace in oracle?

1147

---

What is the relation of a user account and a schema in oracle?

1062

---