Answer Posted / rajesh venati

It is also work,

UPDATE TABLE_NAME SET COL_NAME=NEW_VALUE WHERE
COL_NAME=OLD_VALUE;

EX:-

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
4

SQL> UPDATE RAJ SET EMPNO=400 WHERE EMPNO=4;

1 row updated.

SQL> SELECT * FROM RAJ;

EMPNO
----------
100
200
300
400

What are tables in sql?

1115

---

What are local and global variables and their differences?

1134

---

How do I add a primary key to a table?

1079

---

explain the difference between myisam static and myisam dynamic. : Sql dba

988

---

how to shut down the server with 'mysqladmin'? : Sql dba

1048

---

What is sql character function?

1146

---

How much does sqlite cost?

1094

---

What is sql indexing?

1059

---

What is posting?

1083

---

What are the set operators in sql?

1134

---

How to read xml file in oracle pl sql?

947

---

What is mutating error in pl sql?

1061

---

What is use of trigger?

984

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1488

---

How to read/write files from pl/sql?

1083

---