0D or 0D0A in PLSQL
652398Aug 30 2011 — edited Aug 31 2011A 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.