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;

What is raw datatype in oracle?

1204

---

What are the differences between interval year to month and interval day to second?

1059

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1083

---

Why do we use coalesce function in oracle?

1164

---

What is an index associated with a constraint?

1083

---

How to convert a string to a date in oracle database?

1090

---

what is port in oracle? how is it related to database application.

1991

---

What is procedure overloading in oracle?

1111

---

Explain cascading triggers.

1118

---

What is a cursor variable?

1213

---

Explain an index segment?

1155

---

What are the limitations of check constraint?

1071

---

What is a dynamic performance view in oracle?

1053

---

How to connect to the server with user account: sys?

1058

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2757

---