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

List the ways to get the count of records in a table?

512


What is sequence in sql?

506


What is trigger point?

538


what are sequences

1096


What is cte?

574






What is pivot query?

596


What is the starting oracle error number?

569


Why we use sql profiler?

562


What is the requirement of self-join?

546


Can we use pl sql in mysql?

519


How do you declare a constant?

528


Inline the values in PL/SQL, what does it mean.?

633


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

549


what is 'mysqldump'? : Sql dba

573


Explain autonomous transaction.

636