In a table only one column how to update rows
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / manjuanth
Answer - point 1, 2, 3, and 4 All are correct.
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What packages(if any) has oracle provided for use by developers?
What is the file extension for sql database?
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
What are the qualities of 2nf?
how to get a list of columns in an existing table? : Sql dba
What is pragma exception and how, when, where us
What is user in sql?
What is ON DELETE CASCADE?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How do sql databases work?
How do I save the results of sql query in a file?
how to create a database in oracle?