In this condition, if doc status is "R" and parameter date minus 10feb2014
is positive figure then doc status will be considered as authorised "A"
Regards,
Ashish
On 24-Feb-2014 11:35 PM, "Sagar Thakkar" wrote:
> HI can some explain the case function below specially the DECODE (SIGN
> (TO_DATE (
Amending what I said earlier, having this in the WHERE clause is not a
problem.
WHERE CASE
WHEN Y.DOC_STATUS = 'R' AND DECODE (SIGN (TO_DATE
(:P_CHK_RECD_TO, 'DD/MM/') - (TO_DATE('10/02/2014','DD/MM/'))), 1,
'A') = 'A'
THEN
As far as I can tell:
1) this does not belong in the WHERE clause
2) the entire DECODE function could simply be replaced by (date1 > date2)
Consider the following example:
In case you don't know, DUAL is a table that has one column and one row.
The column's name is "dummy" and the value of the ro
Hi Jyothi,
Yes, a variable, (or table column) with a datatype of DATE can not be
zeros.
The key concept here is DATATYPE, not 'type', not 'data type', but
'datatype'.
These are all different things.
regards,
Mike
On Fri, Aug 12, 2011 at 7:27 AM, JK wrote:
> This problem is resolved.
>
> On l
