Ask A Question

4.5+ million Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!

If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!

Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.

Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.

  1. I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
  2. I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
  3. I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.

Go!

6,263 Comments

  1. Avatar

    Is there a way of directing output from a query in SQLDeveloper to a dynamically named file on disk?

    I am required monthly to produce these CSV files, each named after their month; and I have not been able to programmatically set the name of the file for the SPOOL command.

    On the same topic:

    Is there a way of saving the output of a script to disk? Currently I am using dbms_output.put() and then manually saving the output to a file, but it is messy and error-prone.

  2. Avatar

    Hi Jeff – Your BLob article tells about loading and looking at imagery with blobs in SQLDeveloper but How do I remove a blob from a row. I don’t want to remove the entire column, just the one blob from a row.
    the row contains things like UUID, filename, description, image data as a blob, and a few other things. for my testing, I put in an image and now I want to remove just that one image from my table. I’ve googled it but have not found the answer. Seems like this should be easy and straight forward but it is stumping me.
    Thanks!

    • thatjeffsmith

      I show how to do that, or one way how to do that, here.

      Good or bad, I have way more than 1 ORDS+BLOB posts…

    • Avatar
      Marie Alm

      Hi again – I did an update on that row and set the blob cell to null. It seemed to work. I guess I didn’t need to write you but I didn’t find that way to do it until after I had written you my comment. If I need to do something else to, say, reclaim space, please do let me know. — Thanks.

Reply To Khadim Ali Cancel Reply