Oracle SQL Developer - How to export table with BLOB column?

Posted by Taylor Leese on Stack Overflow See other posts from Stack Overflow or by Taylor Leese
Published on 2010-05-20T23:17:36Z Indexed on 2010/05/20 23:20 UTC
Read the original article Hit count: 1737

Filed under:

Oracle

|

oracle-sqldeveloper

|

blob

|

export

I need to export a table using Oracle SQL Developer that includes a BLOB column. Is this possible? CSV and XML won't work because it has the BLOB column.

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about oracle-sqldeveloper

Oracle SQL Developer - How to export table with BLOB column?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to export a table using Oracle SQL Developer that includes a BLOB column. Is this possible? CSV and XML won't work because it has the BLOB column. >>> More
WM_CONCAT with DISTINCT Clause - Compiled Package versus Stand-Alone Query Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I was writing some program that uses the WM_CONCAT function. When I run this query: SELECT WM_CONCAT(DISTINCT employee_id) FROM employee WHERE ROWNUM < 20; It works fine. When I try to compile the relatively same query in a package function or procedure, it produces this error: PL/SQL:… >>> More
Cannot read value from SYS_CONTEXT

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a PL/SQL procedure which sets some variable in user session, like the following:- Dbms_Session.Set_Context( NAMESPACE =>'MY_CTX', ATTRIBUTE => 'FLAG_NAME', Value => 'some value'); Just after this (in the same procedure), I try to read the value of this flag, using:- SYS_CONTEXT('MY_CTX'… >>> More
How to resolve "TNS-12520 TNS:listener could not find available handler for requested type"?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have brand new MacBook Pro (Mac OS 10.6.3) and installed Oracle's SQLDeveloper. After doing so, I set the connection and was connecting just fine. But after an hour or so I got "TNS-12520 TNS:listener could not find available handler for requested type". I wonder how can I fix it? >>> More
Oracle 11g network configuration

as seen on Server Fault - Search for 'Server Fault'
I installed Oracle 11g Enterprise Edition on my Windows 7 Pro. My problem is that I cannot log into database from other host (local network). When I connect to database using Oracle SQLdeveloper everything is ok as long as I specify 'localhost' in connection configuration. However, when I change… >>> More