Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110


Can a table contain multiple foreign key’s?

983


How to make a copy values from one column to another in sql?

1022


What are the steps for performance tuning.

1317


Explain the difference between rename and alias?

1003


What is the difference between count 1 and count (*) in a sql query?

967


What is the difference between left outer join and left join?

977


What is sqlcontext?

1060


Why is partition used in sql?

1104


Is sql a backend?

1003


Is delete faster than truncate?

994


What is %type in sql?

948


Which is better cte or subquery?

1015


what is datawarehouse? : Sql dba

999


What is a function in oracle pl sql?

1014