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
Is it possible to link two groups inside a cross products after the cross products group has been created?
Can we group by two columns in sql?
Where is sql database stored?
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?
How to get unique records from a table?
What is restrict in sql?
What is record data type?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Is sql free?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are the two types of cursors in pl sql?
how to add a new column to an existing table in mysql? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
Is it possible to pass parameters to triggers?
explain primary keys and auto increment fields in mysql : sql dba