![apex sql add comments apex sql add comments](https://orclqa.com/wp-content/uploads/2020/07/create-table-object-browser-apex-1024x463-600x315.png)
![apex sql add comments apex sql add comments](https://adatis.co.uk/wp-content/uploads/Choose-Aliases-2.png)
I doubt it's the only connector to Salesforce, there have to be some more ODBC-like translation attempts. If you're SQL Server guy - have a look at DBAmp ($$$ again). Haven't played with it either (might be it's just a data loader, not really suited for query editor tasks). I just thought that I would post this in case someone else runs into this problem and so I will have the answer when the problem comes up again.
Apex sql add comments code#
Next you have to modify code handling Process when the user clicks the Submit button. You cannot grant the privilege via a database role. Open LOGIN page in APEX Page Designer : Create new Region: Change the properties for the newly created Region. Last but not least - JitterBit Data Loader got promoted some time ago to be listed in Setup pages. Since APEX runs within PL/SQL you have to have the CREATE TABLE grant issued directly to the schema to be able to create a table in APEX. You might also like web-based tools like the official Workbench - if you're not a fan of providing the credentials in the officially hosted one you can download it and host it on your own machine. I've heard some good stuff about BrainEngine too, didn't try it yet (basic version is free, cough up cash for more). My favorite is Real Force Explorer - has the searchable history of SOQL and Apex snippets, you can select the piece you want to run if you have several queries (like in Oracle's SQLDeveloper). There are some tools that you might like more than the official Flash-based Explorer and the sluggish querying utility in Eclipse IDE. You can comment out pieces of queries you've issued in Apex though. No, I don't think there's a way to use comments in SOQL.