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

Is it possible to link two groups inside a cross products after the cross products group has been created?

765


Can we group by two columns in sql?

727


Where is sql database stored?

676


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

757


How to get unique records from a table?

679






What is restrict in sql?

734


What is record data type?

677


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

719


Is sql free?

667


what is the difference between clustered and non clustered index in sql? : Sql dba

737


What are the two types of cursors in pl sql?

731


how to add a new column to an existing table in mysql? : Sql dba

772


what is the difference between a local and a global temporary table? : Sql dba

739


Is it possible to pass parameters to triggers?

775


explain primary keys and auto increment fields in mysql : sql dba

706