In a table only one column how to update rows

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / ashok

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

Answers were Sorted based on User's Feedback

In a table only one column how to update rows..

Answer / 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

In a table only one column how to update rows..

Answer / geetha

create a table with one column
select sno,rowid from test_table;
then use the rowid to update the col..
update test_table set sno = value where rowid =' '

Is This Answer Correct ?

10 Yes

7 No

In a table only one column how to update rows..

Answer / manjuanth

Answer - point 1, 2, 3, and 4 All are correct.

Is This Answer Correct ?

0 Yes

0 No

In a table only one column how to update rows..

Answer / prerit

update table_name set coloumn_name=value;

Is This Answer Correct ?

2 Yes

3 No

In a table only one column how to update rows..

Answer / geetha

create a table with one column
select sno,rowid from test_table;
then use the rowid to update the col..
update test_table set sno = value where rowid =' '

Is This Answer Correct ?

1 Yes

4 No

Post New Answer