How to output query results to the console not as strings, but as a table?

I

ince2019-03-13 15:35:41

Oracle

ince, 2019-03-13 15:35:41

How to output query results to the console (Script Output) in Oracle SQL Developer not as strings, but as a table as in MS SQL?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

duhbox, 2019-03-13
@ince

1. The result of the sql query is displayed as a table in the Query Result tab by default
2. dbms_output outputs the text to the Script Output tab (if the Dbms Output option is enabled in the View menu)
To display the result of the script in the sql query, the script must be executed in a table function and then you can will make a request to this function
https://docs.oracle.com/cd/B28359_01/appdev.111/b2...