How to see if SQL is correct when a stored procedure in Oracle executes a large SQL statement

When writing a stored procedure in Oracle, a large SQL statement is sometimes used, but when viewed with the Pl/sql tool test you cannot see the SQL, and the discovery can be handled through an Oracle physical temporary table.

Add dbms_output.put_line (' SQL statement to Output ') in the stored procedure;

Then select the stored procedure in the Pl/sql tool, right-click the test execution, and after the execution is done, you can view the SQL results through the Dbms_output window, which is useful