Answer the question
In order to leave comments, you need to log in
Where can I see the result of a query in PL/SQL Developer?
Good afternoon,
I used to work in Oracle SQL Developer, now, when switching to PL/SQL Developer, I ran into a problem: when I run the query, I can't find the result. How to find\turn on the window with results?
Answer the question
In order to leave comments, you need to log in
There you need to open the SQL Window, then enter a query, press F8 and the selection should load at the bottom (by default, the first 20 lines seem to be).
It was about finding, which means it's not about outputting a dataset of a simple select. Probably, here the question is different. I guess the question sounded more like this:
A) how, when using pl/sql developer in the 'command window' tab, to look at the result when using the output in dbms_output.put_line?
Answer: if the info from dbms_output.put_line is not displayed on the screen, cock before the pl script
set serveroutput on
but the question may sound differently:
B) how to look at the result when using pl/sql developer in the 'sql window' tab when using output in dbms_output. put_line?
here the result in the usual place for this window will not be at the bottom of the screen. and the second sub-tab "output" will appear in the run window. There will be a result from the output.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question