Home » SQL & PL/SQL » SQL & PL/SQL » Hoe do i display a newline using pl/sql
Hoe do i display a newline using pl/sql [message #216266] Thu, 25 January 2007 21:06 Go to next message
blueberry
Messages: 1
Registered: January 2007
Junior Member
Hi,
How do i display a newline using pl/sql?
If i will to code in procedure, how do i get a newline also ? Can i put DBMS_OUTPUT.NEWLINE?

For example in my text file, i need to display :

This is a text

Testing
Re: Hoe do i display a newline using pl/sql [message #216267 is a reply to message #216266] Thu, 25 January 2007 21:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Can i put DBMS_OUTPUT.NEWLINE?
In which document is this explained?
You can find the whole Oracle Doc. set at http://tahiti.oracle.com
Re: Hoe do i display a newline using pl/sql [message #216274 is a reply to message #216267] Fri, 26 January 2007 00:14 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would something like this help?
BEGIN
  dbms_output.put_line('This is a text' 
                      || CHR(10)
                      ||'Testing'
                      );
END;
/

[Updated on: Fri, 26 January 2007 00:15]

Report message to a moderator

Re: Hoe do i display a newline using pl/sql [message #216890 is a reply to message #216266] Tue, 30 January 2007 15:44 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
or...

select 'This is a text'||chr(10)||'Testing'
from dual;

Re: Hoe do i display a newline using pl/sql [message #216893 is a reply to message #216890] Tue, 30 January 2007 15:50 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But it is not PL/SQL Smile
Re: Hoe do i display a newline using pl/sql [message #216895 is a reply to message #216893] Tue, 30 January 2007 15:52 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Littlefoot wrote on Tue, 30 January 2007 15:50
But it is not PL/SQL Smile

Sorry, your right, I didn't read the original request close enough.
Previous Topic: date format?
Next Topic: Creating Oracle Directories
Goto Forum:
  


Current Time: Thu Dec 08 08:10:51 CST 2016

Total time taken to generate the page: 0.11247 seconds