SELECT in BI PUBLISHER,?

Question

Oracle

Such a question: is it possible in BI PUBLISHER to use two operators at once (that is, SELECT and INSERT INTO) when creating a report in a SQL query? If yes, please tell me how!

Answer 1

in SQL query you can use MERGE

Answer 2

If the query needs to insert and return the result of inserted values, then you need to use OUTPUT
ms sql