View Single Post
  #2 (permalink)  
Old July 15th, 2003, 10:27 PM
melocy melocy is offline
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please Type chr(10)

scott@PRD.COM> select 'Name:XX'||chr(10)||'SurName:YY'||chr(10)||'Title: ZZ' aa from dual ;
AA
------------------------------------------------------
Name:XX
SurName:YY
Title:ZZ