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 where clause in oracle?

526

---

What is the max number of columns in an oracle table?

507

---

What is the usage of analyze command in oracle?

609

---

What is a proxy class?

551

---

Can a formula column be obtained through a select statement ?

1843

---

---

Explain enable novalidate constraint.

591

---

How to create a table index?

556

---

How to define a variable of a specific record type?

603

---

11. Display the client number and name and the client number and name of the person who referred that client.

1915

---

How would you go about verifying the network name that the local_listener is currently using?

1602

---

What is the use of file param in imp command?

637

---

What are the system predefined user roles?

579

---

Explain the difference between sql and oracle?

574

---

How to revoke create session privilege from a user in oracle?

549

---

What is program global area (pga) in oracle?

601

---