Answer Posted / sudhakar

update <table-name> set column-name<condition> where <condition>
ex:
update dept set desg='manager' where deptid=111;

Oracle

2318

---

How to define an oracle sub procedure?

1046

---

What is system tablespace?

1039

---

Write a syntax for update query in oracle?

967

---

Explain the use of analyse option in exp command.

1063

---

How to apply filtering criteria at group level in oracle?

985

---

How can we create the complete backup of data in the oracle.

2088

---

What is rich query?

925

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2128

---

What is a nested table?

1000

---

How do you store pictures in a database?

946

---

Why oracle is used?

991

---

Explain table?

1057

---

How does Oracle guarantee data integrity of data changes?

2330

---

Use of an integrity constraint is better to validate data. Explain

973

---