It is also work, UPDATE TABLE_NAME SET COL_NAME=NEW_VALUE WHERE COL

In a table only one column how to update rows

Question Posted / rajesh venati

5 Answers
9759 Views
Microsoft, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is pl sql different from sql?

1084

What is recursive stored procedure?

1095

Is natural join same as inner join?

931

What are sql injection vulnerabilities?

981

What is the use of partition by in sql?

990

Why use triggers in sql?

954

What is compilation error in pl sql?

974

How do I find sql profiler?

933

What is update query?

974

How to pronounce postgresql?

1055

What is compute?

1082

How to read/write files from pl/sql?

1035

What is sql profiling in oracle?

1058

Is pl sql a scripting language?

1026

what is the difference between a local and a global temporary table? : Sql dba

1070