Skip to Main Content
Forums

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!

0D or 0D0A in PLSQL

652398Aug 30 2011 — edited Aug 31 2011
A proc code is to insert data into Oracle. The content of data is ended by '0D'.

However, after inserting into database, in PLSQL tools, I see the content is ended by '0D0A' using Hex tab.

Then, I use "spool" tool to export the field of the table from database. The content of field is ended by '0D' in export file.

In my opinion, PLSQL is installed in windows platform, so the format of data display is confirm to norms of windows. Therefore the end of field in PLSQL is '0D0A'. Is that true? Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2011
Added on Aug 30 2011
#plsql
5 comments
2,305 views