SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comparision operators --between ,greater than and less than -performance

n2813Oct 1 2013 — edited Oct 1 2013

Hi ,

I am using between instead of < and greater than operators .

Please let me know which performs better for dates.

I have tried searching online but couldn't succeed in getting and answer.

using between --

TRUNC (O_DT) BETWEEN

TRUNC (MAX_DT) + 1 AND TRUNC (SYSDATE)

using < and > --

TRUNC (RECORD_DT) >= TRUNC (MAX_DT) + 1 AND

--TRUNC (RECORD_DT) < TRUNC (SYSDATE)

Thanks in Advance

This post has been answered by unknown-7404 on Oct 1 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2013

Added on Oct 1 2013

10 comments

6,320 views