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 is union?

651


Is nosql faster than sql?

540


Can we use commit inside a trigger?

521


i have some prob lem to tell me about my self in interview first round ...

1700


How to run sql statements with oracle sql developer?

619






Is it mandatory for the primary key to be given a value when a new record is inserted?

708


Why do we use procedures in sql?

547


What are tables in sql?

548


What is pl sql code?

585


How to disable a trigger name update_salary?

672


Show code of a cursor for loop.

582


Is left join inner or outer?

583


The select into statement is most often used to create backup copies of tables or for archiving records?

559


What is the main reason behind using an index?

552


Is trigger a stored procedure?

502