Recent content by Jim Gust

Is there a way to turn off Alt-Row coloring when exporting to Excel? It does not work well when using a dark theme. I tried using the -- AltRowColor and setting the color to white, but that did not affect the output. Alt color seems to be reading from Window Types|SQL Window|Alternate row...

You are correct that the "main" connection is used with the object browser. In my reporting, I did indicate that both the "main" and current connection are the same. This screenshot better illustrates the issue reported and also points to a new problem which is connection indicator override...

I found my answer. It is linked by owner and object name to the objects browser. Then when you right-click on it you will see the Standard Query objects.

On the query results toolbar, there is a button that allows you to save a query as a Standard Query (.sq file). I have not been able to find a menu, context menu, or window that will use these files. Was this function replaced by templates? I see the same thing with the test window. There...

I have to use an AD account most of the time. Because of this, I hardly ever get a connection match for setting the connection color. That is, until I read there is a general setting that can match just on the database name: Interface|Appearance|Connection Indicators. That setting works for...

Correct, not reproducible.

Now and again, I noticed that when statements run, the first character is not captured. This has probably happened to me 15 times in the last 6 months. I cannot recreate it, which leads me to believe it may be related to disconnection. In the update statement below, notice how the first...

It has been confirmed that GitHub Copilot will be supported in the next version: https://forums.allroundautomations.com/threads/add-support-for-copilot.18054/post-68686

Same here, it's the only one our company is allowed to use. All others are blocked at the corporate firewall.

I'm able to connect using an AD account.

In the SQL Window the parser does not like log_bulk_exceptions and mark_processed procedures in the declaration. This doesn't seem to be an issue for the Program Window. CREATE OR REPLACE PROCEDURE JGUST.SP_local_sub_proc ( p_acad_yr IN NUMBER ,p_lea_id IN...

I use DBMS_SCHEDULER mostly also on Linux we have a couple of cron jobs (equivalent to Windows Scheduler), finally, we also use SQL*Plus. It all depends on the problem you are trying to solve, which would be the best tool.

It looks like different behavior from before, but I do see that CA does return results from inside the CTE not being used in a way not previously tested. -- outside alias is y instead of reusing x. CA does provide listing from dual, but it shouldn't have access to that. WITH temp1 AS (SELECT...

I didn't see the fix listed, but indeed, Code Assistant is now displaying the expected results after installing 16.0.6.2170.

>>* Grid cell spacing and selection area could be too small >>* Ctrl-A did not always select all text in the current grid cell Installed 16.0.6.2170. Both grid cell spacing and CTRL-A in the current grid cell work great. Thank you for the fix.