Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between chr(10) & chr(13)

2946270Apr 1 2016 — edited Apr 1 2016

Hi Everybody,

Hope!! everyone doing well

Could you please help me on the following query

Question:Differnnce between chr(10) 7 chr(13) in oracle. where and how these function are working.

When am executing below queries am getting same output for two queries.

(1)

Begin

dbms_output.put_line('Hi,'||chr(10) ||'good' || chr(13)||chr(10)|| 'morning' ||chr(13)||chr(10) || 'friends');

end;

o/p:

Hi,

good

morning

friends

(2)

begin

   

     dbms_output.put_line('Hi,'||chr(10) ||'good' ||chr(10)|| 'morning' ||chr(10) || 'friends');

    

     end;

Regards,

Annaiah k

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2016
Added on Apr 1 2016
7 comments
63,808 views