If a string is too long to display, we can put character returns using "chr(10)" as shown below. As you can see, we can format the long string better. When we generate a long message such as an email from PL/SQL, chr(0) is very helpful.
SQL> select 'hello world!' as message from dual; MESSAGE ------------ hello world! SQL> select 'hello'||chr(10)||'world!' as message from dual; MESSAGE ------------ hello world!
Post a Comment