In a table only one column how to update rows
Answer Posted / 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 |
Post New Answer View All Answers
What is a common use of group by in sql?
What is group function in sql?
What is use of package in pl sql?
What is trigger in sql? Explain
What is a unique key and primary key and foreign key?
what are null values? : Sql dba
List out the acid properties and explain?
what is a relationship and what are they? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How to run sql*plus commands in sql developer?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
When sql appeared?
Is sql sequential or random?
Why primary key is required?
Why do we create stored procedures & functions in pl/sql and how are they different?