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 a recursive stored procedure?
What are %type and %rowtype for?
How do you truncate?
how to show all tables with 'mysql'? : Sql dba
What are the 3 modes of parameter?
What is tuple in sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is keys and its types?
Is sql easier than java?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is primary key? : Sql dba
How to run sql*plus commands in sql developer?
What is rownum and rowid?
Can two tables have same primary key?
what is bcp? When is it used?