Skip to content

Instantly share code, notes, and snippets.

@shahdhiren

shahdhiren/Export clob field from Oracle SQL Developer

Last active September 27, 2021 10:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save shahdhiren/d9a8b32aeb528078cce92c739d002986 to your computer and use it in GitHub Desktop.
Save shahdhiren/d9a8b32aeb528078cce92c739d002986 to your computer and use it in GitHub Desktop.
Download ZIP
Export Clob data from Oracle
Raw
Export clob field from Oracle SQL Developer
spool clob_export.sql
select /*insert*/ * from <TABLE_NAME> where <FIELD>='88c820c4-b295-466b-a1a3-beb55434e0e9';
spool off
#Stackoverflow: https://stackoverflow.com/questions/42244941/how-to-export-clob-field-datas-in-oracle-sql-developer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment