Hi All,
I have a requirement where my application tries to enter the duplicate row in
table using batchexceute code. And batch exception is thrown we checked error
code and skip it but after this exception all my next update/insert gets error
out with following exception
"Database error. SQL s
David Johnston, 20.09.2011 16:15:
I'm just wondering if this is intended behavioury, simply not (yet)
implemented or even invalid according to the standard? I didn't
find any reference that it's not allowed in the manual.
Regards Thomas
Try sticking the recursive keyword after the "with" if a
On Sep 20, 2011, at 5:58, Thomas Kellerer wrote:
>
> I'm just wondering if this is intended behavioury, simply not (yet)
> implemented or even invalid according to the standard? I didn't find any
> reference that it's not allowed in the manual.
>
> Regards
> Thomas
>
>
Try sticking the rec
Hello all,
this is more a "just curious" question, rather than a real world problem.
We can combine several CTEs into a single select using something like this:
WITH cte_1 as (
select
),
cte_2 as (
select ...
where id (select some_col from cte_1)
)
select *
from cte_2;
But this
