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

How many functions are there in sql?

535

---

Does mysql support pl sql?

622

---

Why select is used in sql?

514

---

What is the maximum size of sqlite database?

546

---

What happens when a trigger is associated to a view?

500

---

---

How do I run a sql query in pgadmin 4?

546

---

What is the difference between a procedure and a function?

490

---

How to use sql statements in pl/sql?

578

---

what is online transaction processing (oltp)? : Sql dba

523

---

Define select, insert, create, delete, update, drop keywords

596

---

Can you inner join the same table?

526

---

How to prepare for oracle pl sql certification?

569

---

Mention what are the benefits of pl/sql packages?

534

---

Explain the difference between sql and mysql.

563

---

How do I edit a stored procedure?

552

---