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 |
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
What do you mean by dbms? What are its different types?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is the difference between function, procedure and package in pl/sql?
What is basic structure of pl sql?
What is the location of pre_defined_functions.
How do you optimize a stored procedure query?
If a View on a single base table is manipulated will the changes be reflected on the base table?
Why is the cursor important?
What language is oracle sql developer?
Is grant a ddl statement?
How do I view a table in sql?