Home » Developer & Programmer » Forms » type letters on different line using sql (form builder 6i)
type letters on different line using sql [message #311865] Mon, 07 April 2008 03:12 Go to next message
omarq
Messages: 8
Registered: May 2006
Junior Member
hi....
i need to type text on different lines using sql statement in the form. my purpose is to send emails through the form, and i want to send some data from the form. i will be using loop, so the attribute will have many values. i want each value to be on separate line?

for example:

while x = 0
select title from xxx;

--email subject will be: " hi these are your files " || xxx
end loop;

Re: type letters on different line using sql [message #311878 is a reply to message #311865] Mon, 07 April 2008 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i want each value to be on separate line

Use concatenation operator along with CHR(10) (line feed):
SQL> select 'First value ' || chr(10) ||
  2         'Second value ' || chr(10)
  3  from dual;

'FIRSTVALUE'||CHR(10)||'SEC
---------------------------
First value
Second value


SQL>
icon7.gif  Re: type letters on different line using sql [message #311886 is a reply to message #311865] Mon, 07 April 2008 04:53 Go to previous message
omarq
Messages: 8
Registered: May 2006
Junior Member
HI .....

That was greate.

Thank you very much.
Previous Topic: update error
Next Topic: how to make balleting application in forms 6i
Goto Forum:
  


Current Time: Fri Dec 02 14:20:57 CST 2016

Total time taken to generate the page: 0.13661 seconds