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 ?    10 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a common use of group by in sql?

997


What is group function in sql?

966


What is use of package in pl sql?

953


What is trigger in sql? Explain

944


What is a unique key and primary key and foreign key?

920


what are null values? : Sql dba

902


List out the acid properties and explain?

904


what is a relationship and what are they? : Sql dba

1027


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2529


How to run sql*plus commands in sql developer?

1086


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

951


When sql appeared?

1025


Is sql sequential or random?

983


Why primary key is required?

939


Why do we create stored procedures & functions in pl/sql and how are they different?

889