Re: [cx-oracle-users] Does cx_Oracle support embedded sql selection?

[Massa, H. A. <ch...@gh...>]

Dehong,

that is no valid Oracle SQL.

To use a query within a FROM-Clause, you have to give an alias. As in

select count(*) from
(
select * from employee
) emp

( I assume we are talking test-sql; no production system should use "select
*" or unrestricted count)

Harald


It seems that cx_Oracle will return syntax error if the sql string has the

> embedded sql selection statements.
>
> such as,
> select count(*) from
> (
> select * from employee
> )
>
> Is there any solution for it?
>
>
-- 
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare