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 are the different ways to optimize a sql query?

889


what is 'mysqlcheck'? : Sql dba

959


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

1004


Does db2 use sql?

889


Is sqlite good enough for production?

949


Explain the difference between rename and alias?

965


What is the source code of a program?

1002


what are the 'mysql' command line options? : Sql dba

1016


Can variables be used in sql statements?

980


What are the different types of tables in sql?

929


How many databases can sql express handle?

942


What is union?

1082


How many sql commands are there?

1071


Can there be more than one function with a similar name in a pl/sql block?

925


what is data manipulation language? : Sql dba

946