f_yes_no( 'The OTB for Category '||classRec.class||' has been exceeded. '|| ' Available Amount is '||l_avail||' and the amount spent was '||classRec.order_cost|| '. Do you want to continue this order in APPROVED/IN TRANSIT?' )
I want the sentence starting with "Available..." to start on the next line, and the sentence starting with "Do you..." on the following line.
Is there some magic "end-of-line" character or something that you are aware of to accomplish this. I hate to guess and do spaces.... looks like sloppy coding.
Try concatenating a carriage return and line feed to your output string. There is a function to return special character in Oracle called CHR. The ASCII value of Carriage return and line feeds are 10 and 13 respectively. So, concatenating CHR(10) || CHR(13) will do the trick for you.
Dig Deeper on Oracle database design and architecture
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.