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


Please Help Members By Posting Answers For Below Questions

what are the drivers in mysql? : Sql dba

552


What is a natural join?

514


What is join view in sql?

510


what is clause? : Sql dba

583


What is pl sql and why it is used for?

570






What is difference between nchar and nvarchar?

538


what is user defined functions? : Sql dba

545


How many types of index are there?

551


Is pl sql different from sql?

530


How many types of triggers exist in pl/sql?

561


How do I debug a stored procedure?

625


What is materialized view. What are different methods of refresh?

777


How to select all records from the table?

605


What is over () in sql?

523


How do I sort a table in sql?

593