OraFAQ Forum: SQL & PL/SQL » updating a particular value in a record.

Home » SQL & PL/SQL » SQL & PL/SQL » updating a particular value in a record.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

updating a particular value in a record. [message #19592]

Sun, 31 March 2002 10:55

ash
Messages: 43
Registered: February 2001

Member

hi.

how can we update a particular value in a record. the problem with using the WHERE clause is as follows:

the table that i have has identical values in all the fields(columns) in all the records(rows). for eg. the table looks like this:

TABLE_A
cloumnA columnB columnC
free free free
free free free
free free free
free free free
free free free

now i just wanst to fill in some value say 'abc' in the first column of the first record.

how can i do that?

Report message to a moderator

Re: updating a particular value in a record. [message #19593 is a reply to message #19592]

Sun, 31 March 2002 21:38

R.SIVAKUMAR
Messages: 48
Registered: February 2002

Member

u can TRY like this

update table_a set cloumnA='abc'
for rownum=1;

***
u can use rownum for this operation

bye
siva

Report message to a moderator

Re: updating a particular value in a record. [message #19606 is a reply to message #19592]

Mon, 01 April 2002 08:37

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Actually, it would be:

update table_a
   set columna = 'abc'
 where rownum = 1;

Report message to a moderator

Re: updating a particular value in a record. [message #19634 is a reply to message #19592]

Tue, 02 April 2002 01:41

Srihari
Messages: 22
Registered: October 2000

Junior Member

Hi

Try this query! If the records in ur table is like this TABLE_A
cloumnA columnB columnC
free free free
free free free
free free free
free free free
free free free

and U want to change nth row columnB value to 'costly'

then

update TABLE_A set columnB='costly' where rowid =
(select max(rowid) from TABLE_A where rownum <= n)

here if n=3 then Third row columnB value will be changed

Hope this is useful

Bye

Srihari

Report message to a moderator

Previous Topic:	insert Problem
Next Topic:	Re: Hierarchial Queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:13:05 CDT 2024