Re: NULL vs. empty

Frank van Bortel wrote:
>
> Oracle treats empty strings as NULLs (OK Daniel...), at least for
> character columns (CHAR, VARCHAR, VARCHAR2, NVARCHAR, NVARCHAR2):
[...]

Hi Frank,

as I mentioned the empty VARCHAR problem is solved by inserting a TAB as value. What I asked is what to do for INTEGER/NUMBER values... It is not possible to reserve a special INT value like '-1' for doing this.

Bye,

   Steffen Received on Wed May 26 2004 - 02:52:04 CDT