Recent content by BJCooperIT

Thanks, John. I would if I had the privileges in that database but, sadly, I am mostly a read-only user and the only table I can insert into is the dba's table dbasch.sqln_explain_plan. Just because they use a different tool than the developers, they think that table is sufficient. Grrr... What...

I have been tasked with running Explain Plans in a database where the EXPLAIN_PLAN table resides, but with a different table name (Thanks DBAs! :mad:). Is there a way I can point the Explain Plan window to a different output table?

In version 7.0.3.1123 when I attempt to copy the results of an explain plan with Description and Object Name, it embeds "Object Name=" in the results for each line: Description Object name SELECT STATEMENT, GOAL = HINT: RULE SORT ORDER BY NESTED LOOPS OUTER MERGE JOIN VIEW...

It would be nice to have an option to have other keywords start on the next line and be aligned. AFTER BEAUTIFYING: WHERE add_months(ips.inspenaltysmry_created_dt, -1) BETWEEN to_date('' || p_startrange || '', 'MM/DD/YYYY') AND to_date('' || p_endrange || '', 'MM/DD/YYYY')...

The steps are pretty much as I described. If the changes only take place after "rerunning the Plan Window", then what is the difference between the "Apply" button and the "OK" button? Both accept your changes which only appear when you run another Explain Plan.

Scenario: 1. There is an Explain Plan window open and I click the Preferences icon. 2. I then add, delete or move a column within my preferences. 3. Then I click the "Apply" button. 4. Now I click the "OK" button. When I return to the open Explain Plan window the changes have not been made to...

I have resolved this problem. I had accidentally modified the directory for templates my SQL directory.

In version 7.1.5.1398, where are the code samples in the template list? All I see is: - Manuals | + B19306_01 - RegExpSample | | | |- doc | | | |- src - source Under the B19306_01 I see lots of entries that seem to refer to documentation, like "readmes".

Yes, now I can create a macro without it hanging up. I was able to add it to the library and give it a name. But how do I get it to add it to my macro drop down list or add it to a toolbar? The popup looks nothing like the display in the help documentation.

I just installed Version 7.1.5.1398 / Windows XP Professional 5.1 Build 2600 (Service Pack 3) to get the fix for macros. Now, F11 starts macro recording, but then keystrokes have no effect and even F11 does not end macro recording. The session hangs and has to be shut down. It there a fix?

Thanks Marco, keep up the good work!

I had an existing query something like: SELECT * FROM SUPERVISOR_TAB WHERE SUPERVISOR_CODE in( 2, --Bill 7, --Frank 10, --Marcia 15) --Sarah I then used query builder to add a table and specific fields to the query and the result was...

Quote from the Help Manual: "When you press enter while the Code Assistant is visible, the name of the currently selected item will be inserted into the source." In version 7.0.1.1066, if I press enter while the Code Assistant window is displayed, all I get is a carriage return inserted. I have...

I have sent you an email. Thanks for looking into this.

No. The session just stopped responding.