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 a recursive stored procedure?

1180


What are %type and %rowtype for?

1052


How do you truncate?

906


how to show all tables with 'mysql'? : Sql dba

1118


What are the 3 modes of parameter?

1154


What is tuple in sql?

1075


In pl/sql, what is bulk binding, and when/how would it help performance?

994


What is keys and its types?

1074


Is sql easier than java?

1008


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3567


what is primary key? : Sql dba

1028


How to run sql*plus commands in sql developer?

1156


What is rownum and rowid?

1030


Can two tables have same primary key?

975


what is bcp? When is it used?

1107