Forum Discussion

soptim_vond's avatar
soptim_vond
Frequent Visitor
7 years ago

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 BI, I always get the following error:

ORA-00933: SQL command not properly ended

 

Is there a way to get around this?

 

Separating the two statements is not an option because the order in which they are processed matters and manipulating query order in Power BI is tricky...

 

Thanks in advance,

 

Nico

Need Help

6 Replies

    • soptim_vond's avatar
      soptim_vond
      Frequent Visitor
      7 years ago

      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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Nico,

         

        Can you just send me that query?

         

        Because, Power BI will not support ;(semicolon) in SQL Editor. You need to have oracle connector to establish the connection with Oracle DB.

         

        If you are using SQL Editor for your Oracle query, then it is wrong.

        Or, you can split these two tables and make relations in the data model and then move to further development.

         

        Regards,

        Pradeep