RE: how to restrict query results using date calculations

From: William Threlfall <William.Threlfall_at_albertahealthservices.ca>
Date: Mon, 3 Feb 2014 15:16:41 -0700
Message-ID: <36800EC4761690448F1B444A1AEF44BB0E51E4CA_at_EXMBXC5.crha.bewell.ca>



Thanks Riyaj. Adding another SQL SELECT layer was so simple it never occurred to me. It worked fine. :)

Cheers, - Bill.

From: Riyaj Shamsudeen [mailto:riyaj.shamsudeen_at_gmail.com] Sent: Thursday, January 30, 2014 2:07 PM To: William Threlfall
Cc: Oracle-L_at_freelists.org
Subject: Re: how to restrict query results using date calculations

Hello Bill
  It may be readable to enclose the statement in an inline view and then appy the predicate. Here is an example:



This message and any attached documents are only for the use of the intended recipient(s), are confidential and may contain privileged information. Any unauthorized review, use, retransmission, or other disclosure is strictly prohibited. If you have received this message in error, please notify the sender immediately, and then delete the original message. Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 03 2014 - 23:16:41 CET

Original text of this message