Skip to Main Content

SQL Developer

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!

sql developer spool command issue.

User_DOA25Aug 11 2022

We are using oracle sql developer version 21.4 in our machine. when try to spool the data for insert statements, data is coming with q notation (q'[aa]). This causing issue when we deploy the same spool file through liquibase. We are having large datasets it is difficult to replace the value. This issue is not there in oracle sql developer version 17.1 . Recently all our machines are migrated to windows10 and it is not supporting older version of sql developer. Kindly check and let us know. How to avoid q notation while spooling data in oracle sql developer version 21.4.

Comments
Post Details
Added on Aug 11 2022
8 comments
624 views