OraFAQ Forum: Forms » type letters on different line using sql

Home » Developer & Programmer » Forms » type letters on different line using sql (form builder 6i)

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

type letters on different line using sql [message #311865]

Mon, 07 April 2008 03:12

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;

Report message to a moderator

Re: type letters on different line using sql [message #311878 is a reply to message #311865]

Mon, 07 April 2008 04:27

Littlefoot
Messages: 21823
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>

Report message to a moderator

Re: type letters on different line using sql [message #311886 is a reply to message #311865]

Mon, 07 April 2008 04:53

omarq
Messages: 8
Registered: May 2006

Junior Member

HI .....

That was greate.

Thank you very much.

Report message to a moderator

Previous Topic:	update error
Next Topic:	how to make balleting application in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 11:43:44 CDT 2025