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


Please Help Members By Posting Answers For Below Questions

What are some emotional triggers?

570


What is #table in sql?

523


discuss about myisam index statistics collection. : Sql dba

530


How many joins can you have in sql?

521


What are predefined functions in sql?

535






What are analytic functions in sql?

550


what is cursor. write example of it. What are the attributes of cursor.

745


What is lexical units in pl sql?

571


Name the different types of indexes in sql and define them.

570


How to pronounce postgresql?

582


What is a unique constraint?

610


Does a user_objects view have an entry for a trigger?

570


Advantages and disadvantages of stored procedure?

580


What is the use of procedures?

544


What sql does db2 use?

544