Results 1 to 2 of 2

Thread: Pass Oracle hints into a Power Query

  1. #1
    Seeker kkalomiris's Avatar
    Join Date
    Dec 2016
    Excel Version

    Pass Oracle hints into a Power Query

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Oracle hints error.jpg 
Views:	13 
Size:	71.3 KB 
ID:	7330  

  2. #2
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts