Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_OUTPUT how to include a white space (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0)
DBMS_OUTPUT how to include a white space [message #689506] Thu, 25 January 2024 10:00 Go to next message
wtolentino
Messages: 404
Registered: March 2005
Senior Member
How to get the dbms_output.put_line() to output a whitespace?


/forum/fa/14785/0/


[Updated on: Thu, 25 January 2024 10:14]

Report message to a moderator

Re: DBMS_OUTPUT how to include a white space [message #689508 is a reply to message #689506] Thu, 25 January 2024 10:43 Go to previous messageGo to next message
wtolentino
Messages: 404
Registered: March 2005
Senior Member
I got it to work by

set serveroutput on format truncated;


/forum/fa/14786/0/

Re: DBMS_OUTPUT how to include a white space [message #689509 is a reply to message #689508] Thu, 25 January 2024 11:15 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

TRUNCATED is not a mandatory choice, you can use in the same way WRAPPED or WORD_WRAPPED to prevent for your output to be truncated.
Actually, it is the keyword FORMAT that leads SQL*Plus to keep the spaces.

[Updated on: Thu, 25 January 2024 11:22]

Report message to a moderator

Previous Topic: VSIZE() function's meaning and physical storage size
Next Topic: What is the difference between varchar2 and nvarchar2?
Goto Forum:
  


Current Time: Mon May 27 01:24:02 CDT 2024