Forum Stats

  • 3,760,198 Users
  • 2,251,663 Discussions
  • 7,871,021 Comments

Discussions

Syntax highlighting & Query pane issue

Hello,

I am having a weird bug as the syntax highlighting is missing in my queries for the JOIN keyword.

If I use the Language PL/SQL extension with 'PLSQL' as language for the files, then it works but I cannot run the queries using ODT.

To run queries with ODT, I need to change the language to 'Oracle-SQL and PLSQL' but then I have this issue in my queries.

Any help ?












Also, after running a query, the results pane is hidden and I have to scroll every time.

Is this a bug ? Is there a way to fix the layout to get the results directly ?

Thank you,

Answers

  • Hi,

    To confirm is the issue strictly with the syntax highlighting, or do you have errors when you execute it?

    As for the results, I am not sure what you mean. Are you saying that there are existing output that you have to scroll though?

    If so, you can use the setting Oracledevtools › Query: Clear Results Window to clear the results each time.

    If you want to change the layout of your screen, you can try this:

    In the VS Code menu, select View->Editor Layout->Two Rows.

    Execute some SQL or PL/SQL

    Drag the SQL results tab into the lower pane.

    Please let me know more details of your problems if these do not fix it.

  • User_C7VVA
    User_C7VVA Member Posts: 6 Green Ribbon
    edited Jul 16, 2021 1:25PM

    Hello Christian,

    Thank you for your answers.

    1) There are no errors when I execute the queries... So it is only related to syntax highlighting.


    2) I changed the layout to two rows, and I used 'Clear Results Window' but I have the same issue, see below.

    With a very short query, it looks like this, results are seen directly:


    With a longer query, query is shown first and results are hidden (even if there is only a row)

    Focus is on the query that ran, but I believe it should be on the results.

    And I have to scroll every time to see the results:


  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,936 Employee
    edited Jul 19, 2021 8:48PM

    Hi,

    I believe we have fixed the syntax highlighting bug in the next release. When the next version comes out, please give it a try.

    As for being forced to scroll, can you try turning off ECHO so that the SQL statement is not sent to the output? With that setting and automatically clearing results, then you will not have to scroll.

    In the settings, uncheck Oracledevtools › Query: Echo

    and also check Oracledevtools › Query: Clear Results Window

    Let me know how that goes....

  • User_C7VVA
    User_C7VVA Member Posts: 6 Green Ribbon
    edited Jul 20, 2021 2:33PM

    OK, understood for the highlighting, I will check it in the next version.

    When echo is off, and clear results window is on, I have the desired layout, centered on the results. I will use this setup, thank you.

    When echo is off, and clear results is off, after 3/4 executions, the results fill the screen and I have to scroll. It could be interesting to see the previous executions and to have the window centered on the last one at the same time.

  • Ok, got it. I will include "auto scroll output to last result" in our feature request list.

  • User_C7VVA
    User_C7VVA Member Posts: 6 Green Ribbon

    Great, thank you !

  • This issue with scrolling properly to see the last result should be fixed in 21.3.0. Please try it out and let me know.

  • User_C7VVA
    User_C7VVA Member Posts: 6 Green Ribbon