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 is the reports view in oracle sql developer?

997

---

How much does sqlite cost?

1045

---

what are properties of a transaction? : Sql dba

1094

---

How to start the command-line sql*plus?

1058

---

What is rename command in sql?

1039

---

Which command is used to delete a trigger?

1335

---

What do you mean by dbms? What are its different types?

1019

---

Is join and inner join the same?

1008

---

How do I edit a trigger in sql developer?

1000

---

What is the usage of when clause in trigger?

1057

---

How do you create a db file?

1020

---

what are the nonstandard string types? : Sql dba

1144

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3053

---

What is a string data type in sql?

1046

---

Is primary key is clustered index?

1002

---