Forum Discussion
Is it possible to include multiple SQL-Statements in one query (ORACLE)?
Hi folks, usually, working with an oracle database in a standard SQL-editor multiple sql-statements can be entered in one query separated by a semicolon. However, when I try to do that in Power B...
Hi soptim_vond,
It seems that your query has ended up with the incorrect syntax.
Please go through the below URL.
https://www.techonthenet.com/oracle/errors/ora00933.php
Regards,
Pradeep
Hi Pradeep,
thanks for reply, but the syntax is correct. The statement containing the two substatements separated by a semicolon works fine in a standard SQL-editor. And both substatements work in power bi as well, as long as I put them in seprate queries. Things go wrong as soon as I use a semicolon to separate the two statements.
Regards,
Nico