Home » SQL & PL/SQL » SQL & PL/SQL » How to update a Long field in Oracle
How to update a Long field in Oracle [message #185507] Wed, 02 August 2006 01:37 Go to next message
hskramesh
Messages: 2
Registered: July 2006
Location: Chennai
Junior Member
Hi,

kindly tell me the solution to update a Long field

Regards
RAMESH KUMAR.K
Re: How to update a Long field in Oracle [message #185523 is a reply to message #185507] Wed, 02 August 2006 02:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What problem are you having with using the UPDATE statement?

If you tell us what you are trying to do, show us what you've already tried, and let us know what the problem you hit was, we may be able to help.
Re: How to update a Long field in Oracle [message #185556 is a reply to message #185523] Wed, 02 August 2006 05:36 Go to previous messageGo to next message
hskramesh
Messages: 2
Registered: July 2006
Location: Chennai
Junior Member

It shows the following error,

"can not inserted too many column"

Regards
Ramesh Kumar

Re: How to update a Long field in Oracle [message #185557 is a reply to message #185556] Wed, 02 August 2006 05:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
My awesome psychic abilities tell me that this isn't actually the error message that you're getting.
Is your actual error:
ORA-00913: too many values
or
ORA-01401: inserted value too large for column
or is it something else
Previous Topic: Sql query need to pivot table format
Next Topic: suffix or prefix negative value of the column
Goto Forum:
  


Current Time: Fri Dec 09 21:30:33 CST 2016

Total time taken to generate the page: 0.05398 seconds