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 define an anonymous procedure with variables?

760

---

What is an oracle table?

752

---

How to drop an index in oracle?

806

---

Explain the difference between replace() and translate() functions in oracle?

801

---

When do you get a .pll extension in oracle? Explain its importance

788

---

How to test null values?

848

---

Explain drop constraint oracle?

793

---

How do you store pictures in a database?

746

---

How can we view last record added to a table?

804

---

What is oracle server autotrace in oracle?

858

---

What is the difference between truncate & delete command?

869

---

What are transaction isolation levels supported by oracle?

779

---

Explain the features of oracle?

800

---

what is the difference between data migration and production migration.

2049

---

Can you create a synonym without having a table?

773

---