Tuesday, January 30, 2018

Oracle forms how to feed new line

Carriage returns = 13 
Line Feeds = 10 
Tabs = 9 

(and other ascii codes..) Once you know the code, getting them from the database is easy. There is a function chr() that will take the ascii code and return the character. So, if you: 

myString := 'Some Text' || chr(10) || 'Some more Text....';

No comments:

Post a Comment