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

How many types of primary keys are there?

710


What is cursor explain with example?

733


What is #table in sql?

704


What is trigger types in sql?

714


What is trigger explain with example?

751






What is sap sql?

716


What kind of join is join?

702


How is a PL/SQL code compiled?

862


how to fetch common records from two tables? : Sql dba

842


What is group function in sql?

749


Is sql difficult?

922


What are the types of join and explain each?

771


Explain spool.

900


Explain unique key in sql.

738


Does asenumerable execute the query?

775