cx-oracle-users

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

[<Deh...@me...>]

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?

This message and any attachment are confidential and may be privileged or
otherwise protected from disclosure. If you are not the intended recipient,
you must not copy this message or attachment or disclose the contents to
any other person. If you have received this transmission in error, please
notify the sender immediately and delete the message and any attachment
from your system. Merck KGaA, Darmstadt, Germany and any of its
subsidiaries do not accept liability for any omissions or errors in this
message which may arise as a result of E-Mail-transmission or for damages
resulting from any unauthorized changes of the content of this message and
any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its
subsidiaries do not guarantee that this message is free of viruses and does
not accept liability for any damages caused by any virus transmitted
therewith.

Click http://disclaimer.merck.de to access the German, French, Spanish and
Portuguese versions of this disclaimer.

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

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/5/23  <Deh...@me...>:
>
> 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?

cx_Oracle does not try to parse the SQL statement, it passes it
directly to the Oracle server.
Like sql*plus... except that the semicolon at the end must be removed!
Do you have an example of code that fails?

-- 
Amaury Forgeot d'Arc

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

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

[Gerrat R. <gri...@co...>]

Harald,

The original sql is valid Oracle SQL, and works fine with cx_Oracle.
The only time you need to provide an alias is when you directly refer to the subquery 
somewhere else in your query.
You may be thinking of another RDBMS (like MS Sql Server).


Dehong,
Perhaps you could provide the error you're getting and, as Amaury mentioned, 
the exact sql statement you're trying.


Massa, Harald Armin wrote on 2011-05-23:

> 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?
> 
> 
> 
>

Regards,
Gerrat