Re: Remove Date overlap duplicates

yossarian wrote:
CarlosAL wrote:

You may use OVERLAPS predicate, which is an ANSI SQL standard used in
others RDBMS (Teradata, for example). It is in Oracle (undocumented
though) since version 10(?).

Thank you for sharing this info, never heard of it, very useful!

While googling for details I found this article:

http://oraclesponge.wordpress.com/2008/06/12/the-overlaps-predicate/

The author uses this construct everywhere:

date '2007-01-01'

I never saw this syntax and I'm not able to found documentation about it
(perhaps I'm using the wrong keywords...). Can you point me to a link?

Thank you.

Kind regards, Y.

It is ANSI SQL-92 Standard. I think Oracle supports it since version 9.

Best regards, Sebastian

.

Relevant Pages

  • Re: Remove Date overlap duplicates
    ... others RDBMS (Teradata, for example). ... It is in Oracle (undocumented ... Thank you for sharing this info, never heard of it, very useful! ...
    (comp.databases.oracle.server)
  • OT: How I learned to stop worrying and love the RDBMS
    ... After several years of working with Oracle doing migrations from MPE/IMAGE ... selecting an RDBMS as a migration target from IMAGE ... The capabilities afforded by a proper RDBMS are astounding and are growing ...
    (comp.sys.hp.mpe)
  • Re: OT: How I learned to stop worrying and love the RDBMS
    ... Denys, I tend to use MySQL mostly because my data requirements are typically modest for what I do for myself or most of my clients, but I did spend a fair bit of time with PostgreSQL some years ago and was very amazed at how well it scaled, even in direct competition with Oracle. ... selecting an RDBMS as a migration target from IMAGE ... The capabilities afforded by a proper RDBMS are astounding and are growing ... To join/leave the list, search archives, change list settings, * ...
    (comp.sys.hp.mpe)
  • Re: OT: How I learned to stop worrying and love the RDBMS
    ... ORACLE and SQL Server, and I can tell you this, the current RDBMS ... The capabilities afforded by a proper RDBMS are astounding and are ...
    (comp.sys.hp.mpe)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)