SQL Developer
Reports -> User Defined Reports -> Edit Report -> SQL Query -> Style: PL/SQL DBMS Output
In the PL/SQL code there are multiple dbms_output statements:
Such as:
dbms_output.put_line('Running script on Server: ' || v_hostname || ' Instance: ' || v_instance || ' and Database: ' || v_database || ' ' || chr(10) || chr(13));
And:
dbms_output.put_line('OK: Database is missing ' || objCount || ' NAMED indexes of 198 Indexes used on the tables involved in The Process ');
The output does not contain carriage returns. Adding chr(10) and chr(13) has no effect.
Current Output #1:
Running script on Server: MYSERVERD01 Instance: DBINSTAA and Database: MYSPACE OK: Database is missing 0 NAMED indexes of 198 Indexes used on the tables involved in The Process
Desired Output #1:
Running script on:
Server: MYSERVERD01
Instance: DBINSTAA
Database: MYSPACE
OK: Database is missing 0 NAMED indexes of 198 Indexes used on the tables involved in The Process
Current Output #2 Example:
Running script on Server: MYSERVERD01 Instance: DBINSTAA and Database: MYSPACE ERROR: Database Missing 2 Named Indexes Missing Index SUB_GROUP_IDX1W Missing Index SUB_GROUP_IDX2W
Desired Output #2:
Running script on:
Server: MYSERVERD01
Instance: DBINSTAA
Database: MYSPACE
ERROR: Database Missing 2 Named Indexes
Missing Index SUB_GROUP_IDX1W
Missing Index SUB_GROUP_IDX2W
Oracle-communities-sql-developer-code-example.txt (2.07 KB)