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 ? | 1 Yes | 4 No |
Post New Answer View All Answers
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Can a table contain multiple foreign key’s?
How to make a copy values from one column to another in sql?
What are the steps for performance tuning.
Explain the difference between rename and alias?
What is the difference between count 1 and count (*) in a sql query?
What is the difference between left outer join and left join?
What is sqlcontext?
Why is partition used in sql?
Is sql a backend?
Is delete faster than truncate?
What is %type in sql?
Which is better cte or subquery?
what is datawarehouse? : Sql dba
What is a function in oracle pl sql?