OraFAQ Forum: SQL & PL/SQL » Carriage return function in Oracle?

Home » SQL & PL/SQL » SQL & PL/SQL » Carriage return function in Oracle?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Carriage return function in Oracle? [message #8296]

Thu, 07 August 2003 10:56

Shaad
Messages: 8
Registered: July 2003

Junior Member

Is there a charriage return function in Oracle that I can use in between two dbms_output.put_line('some text'); statements?

Eg.
dbms_output.put_line('some text');
CARRIAGE RETURN HERE TO SKIP A LINE.
dbms_output.put_line('some more text');

SELECT 'First Name: Sam' || CHR(10) || 'Last Name: Smith' text from dual; works fine from SQL Plus.

Thanks,
Shaad

Report message to a moderator

Re: Carriage return function in Oracle? [message #8297 is a reply to message #8296]

Thu, 07 August 2003 11:03

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

SQL> BEGIN
  2   DBMS_OUTPUT.PUT_LINE('Line 1');
  3   <a href="http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_outpu2.htm#1000419"><font color=red>DBMS_OUTPUT.NEW_LINE;</font></a>
  4   DBMS_OUTPUT.PUT_LINE('Line 2');
  5  END; 
  6  /
Line 1
  
Line 2
  
PL/SQL procedure successfully completed.
  
SQL>

Report message to a moderator

Previous Topic:	A query required to print the row as a Column
Next Topic:	Exceptions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:11:54 CDT 2024