|
[oracle-l]
||
[Date Prev]
[08-2007 Date Index]
[Date Next]
||
[Thread Prev]
[08-2007 Thread Index]
[Thread Next]
Re: CHR(0) ver null
- From: "Thomas Day" <tomdaytwo@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Aug 2007 14:44:53 -0400
This works perfectly fine for me in 10.2
select OWNER, TABLE_NAME from dba_TABLES where owner >= CHR(0)
AND TABLE_NAME >= CHR(0)
ORDER BY 1,2
On the other hand "null" is undefined. It's not CHR(0).
On 8/2/07, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote:
>
> Hello
>
> What component in DB I have to install to use ">= CHR(0)" instead of
> "is not null" .
>
>
>
> --
> Wojciech Skrzynecki
> Database Administrator
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
|
|
