M
M
ma232021-08-20 17:01:59
Oracle
ma23, 2021-08-20 17:01:59

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

2 answer(s)
R
romaro, 2021-08-26
@ma23

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).
6127c7ace50a5896893102.jpeg

A
alex_losk, 2022-04-06
@alex_losk

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 question

Ask a Question

731 491 924 answers to any question