OraFAQ Forum: Server Administration » Update on LONG Column

Home » RDBMS Server » Server Administration » Update on LONG Column

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

Update on LONG Column [message #372651]

Fri, 02 March 2001 02:53

Rajasekaran
Messages: 3
Registered: March 2001

Junior Member

Is it possible to update a particular value in LONG column field?

Report message to a moderator

Re: Update on LONG Column [message #372658 is a reply to message #372651]

Fri, 02 March 2001 09:27

ramu
Messages: 82
Registered: February 2001

Member

Hi Rajasekaran,

Where are you from?

You can update the long column values by the following statement..

If you have a table A and only one column say LON and its type is LONG, then Try this..

First do this..

SELECT ROWID,LON FROM A;

You can see the values now.

Then you can update the particular record now..

Try this..

UPDATE A SET LON='some_value' WHERE ROWID='The_corresponding_rowid';

If you have more than one column for example if you have a column A along with LON then try this..

UPDATE A SET LON='some_value' WHERE A=value;

You can not update a LONG data type column by cheking the field itself..

Thanks..

Ramu..

Report message to a moderator

Re: Update on LONG Column [message #372679 is a reply to message #372651]

Fri, 02 March 2001 19:46

Rajasekaran
Messages: 3
Registered: March 2001

Junior Member

Thanks Ramu, Actually i want to update long column field itself.. so it is not possible.
Anyway i am from Kuala Lumpur, Malaysia working for a telecom industry. what about you???

Report message to a moderator

Re: Update on LONG Column [message #372683 is a reply to message #372679]

Sat, 03 March 2001 00:08

ramu
Messages: 82
Registered: February 2001

Member

Hi,

Could you send me your mail id? I am working here in Bangalore as a programmer. My native is Karur, Tamilnadu.

Thanks..

Ramu..

Report message to a moderator

Previous Topic:	Re: sql primer, date question
Next Topic:	Re: sql primer, date question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 16:32:32 CDT 2024