Answer Posted / irshad ahmad

SQL> UPDATE table_name SET column1=value,
column2=value2,...
[WHERE condition];
for Example:-
Sql> UPDATE customers SET address = ‘250 Azad Road’ WHERE
customerid = 4;

How to delete multiple rows from a table in oracle?

1058

---

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.

2179

---

Explain how you would restore a database using RMAN to Point in Time?

2139

---

What are the advantages of oracle?

1024

---

How can we delete duplicate rows in a table?

971

---

What is an external table?

1012

---

Explain drop constraint oracle?

1054

---

What is ordinary table in oracle?

1150

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

989

---

How to assign values to variables?

1095

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1936

---

How will you identify oracle database software release?

1002

---

How do I manually uninstall oracle client?

1082

---

How to see the table columns used in an index?

1017

---

How to create an oracle database?

1034

---