Home » SQL & PL/SQL » SQL & PL/SQL » chekcing the length of a LONG field
chekcing the length of a LONG field [message #199976] Fri, 27 October 2006 04:46 Go to next message
matpj
Messages: 115
Registered: March 2006
Location: London, UK
Senior Member

is it possible to check the length of a long field.
I have transferred data into an Oracle table.
we would like to perform some functions on the data but we had to create the field as datatype LONG.
Some records have a special character (looks like a thick pipe character)
All we need to be able to do is select all records that are null (or have the special character)

IS NULL works for this, but obviously does not count those with the special character.

can anybody advise?

thanks in advance,
Matt
Re: chekcing the length of a LONG field [message #199981 is a reply to message #199976] Fri, 27 October 2006 05:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try Google. It works most of the times.

oracle forum

By
Vamsi.
Re: chekcing the length of a LONG field [message #200034 is a reply to message #199976] Fri, 27 October 2006 09:40 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
You did not have to create it as long, which nothing works on. You could have created it as CLOB or BLOB which are fully supported.
Previous Topic: bulk analytic update
Next Topic: insert two records
Goto Forum:
  


Current Time: Thu Dec 08 12:07:59 CST 2016

Total time taken to generate the page: 0.10719 seconds