Pass Oracle hints into a Power Query

kkalomiris

New member
Joined
Dec 22, 2016
Messages
5
Reaction score
0
Points
0
Excel Version(s)
365
Hello,
do you know how I can pass Oracle hints, produced from trace plan, into a power query?
When I copy-paste the original code, which is executed thru SQL developer, it gives me an error when it tries to parse the oracle hints part.
A print screen of the error is attached.

Thank you
 

Attachments

  • Oracle hints error.jpg
    Oracle hints error.jpg
    71.3 KB · Views: 16
Your SQL text is a string within quotes, and you have quotes within that. Maybe try using single quotes within the string, or double-up on the embedded quotes.
 
Back
Top