Wednesday, December 13, 2006

Undocumented OVERLAPS

SQL*Plus: Release 10.2.0.1.0 - Production on On Dec 13 23:36:15 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> select 'yes' from dual where (sysdate-5,sysdate) overlaps (sysdate-2,sysdate-1);

'YE
---
yes

SQL> select 'yes' from dual where (-5,0) overlaps (-2,-1);
select 'yes' from dual where (-5,0) overlaps (-2,-1)
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER


See ANSI_SQL - Overlaps

0 Comments:

Post a Comment

<< Home