Ask A Question

5,000,000+ 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,511 Comments

  1. Avatar
    Michael Moser Reply

    Hi – I have a question re. placeholders (the ones with &name or &&name)
    We were developing a complex query which contains a couple of placeholders. First we had them defined using &name only but since it was tedious having to reenter their values again and again we replaced them with &&name. After that SQLDeveloper didn’t ask again (since the value was already defined). This was good for development.
    But now – after having finalized the query – we actually want to use that query using *different* values for the placeholders. So we changed all the && back to & but odd enough, SQLDeveloper still doesn’t ask for the value but recycles the old ones, i.e. we get no prompts. 🙁
    How do we teach SQLDeveloper to forget those old values and prompt us again?

    • Avatar
      Michael Moser

      Sorry, there was no “reply” for your append, thus as new question:

      @Jeff Smith
      > try adding this to the top of your script
      > undefine name

      Thanks – that worked!
      I assume there is no command or menu-option to remove ALL values defined in that way in one go, is there? Just as hint for a little improvement. 😉

  2. Avatar

    Hi Jeff, is there a “sql only” script to install all the required ords objects/schemas in the database? Equal to the installer at the point “Enter 1 if you want to verify/install Oracle REST Data Services schema”. Background: I want to (re)create my pdb completely by sql script from scratch for automated tests.

  3. Avatar

    How to pass date and time parameters in ords query .

    current datetime format: “2021-08-30T04:26:39.472Z

  4. Avatar

    Hi Jeff,

    I have multiple connections defined in SQL Dev and i would like to have a script to call out via connect commands to multiple of those connections running specific scripts against each connection/schema.

    I have tried the usual conn/connect user/[email protected] but that doesn’t work – I’m sure i saw a piece on it a while ago but cant recall the correct way to get it to work.

    Thanks in advance

    Paul

    • thatjeffsmith

      Using either ezconnect or tns on your CONNECT commands should work just fine.

      Those connections will be closed as soon as your script session is concluded.

  5. Avatar

    Hi, Jeff.
    How do I open a second (or third) tab for a table in SQL Developer 20.2+?
    I can right-click and split the table, but can’t find that “clone” option that existed in old versions?.

  6. Avatar

    Hi,

    we want to use ORDS services as a paid service for the clients of our customer. To be able to know how many times a services has been called, we log in each service the request of the customer.
    Now we want to block the request when the customer has no more credits to call this service.
    For the put, post, delete operations, we are able to inject a plsql call to verify this and react as necessary.

    But how do we do this for a get-call? Is there a way to inject plsql logic, which writes data to the db, into a get call?

    Thank you in advance.

    Filip Huysmans

    • thatjeffsmith

      Use the prehook feature. That will get called for EVERY request. When your user exhausts their limit, kick in your logic. They’ll never even get to the actual ORDS code path if you return a FALSE from your prehook function.

      Apart from the Docs, some nice examples here from a customer.

  7. Avatar
    Amin Adatia Reply

    SQL Dev 21.2.1 and also 21.2.0
    When trying to get the SQL for a Partitioned Table, there is nothing specifying the partition definition. This did not happen in 19.4.0

    Regards

  8. Avatar

    Yeah, so SQL Developer wasfreezing up with a message about “Comparing body to … something or the other”.
    So I put it into a Search Engine and I get this:
    https://community.oracle.com/tech/developers/discussion/4283208/sql-developer-hangs-on-comparing-subprograms
    So I disable “Supported Sync Spec and Body” in Preferences as you suggested there. Restart required.
    Guess what? It deleted ALL my passwords. I know, I know, I SHOULD have backups somehwere but .. UGH, wow, man. What the heck? I did NOT expect that.
    I have passwords that I can’t exactly get back very easily. The ones I really need. Of course.
    Wow. Is it supposed to work this way? Shouldn’t there be some kind of notice?
    Thanks again.
    – Mike Kemp

    • thatjeffsmith

      So I JUST tried this in 21.2, and after restart, all of my connections are still here.

      No, that’s obviously not supposed to happen. This was in version 21.2? It’s where I just tried your scenario as described.

    • Avatar
      Mike Kemp

      OK, thank you. I’ll update my version. Thanks again!!

  9. Avatar

    Hi Jeff,
    Now that I know what you actually read this and respond, well. Huh … I can really have some fun!! Moohaha .
    Just kidding.
    Maybe not.
    On a serious note, though, I do have another bug to report.
    I am on 20.4.1.407, Build 407.0006.
    When I navigate from tab to tab using the keyboard (Ctrl + Tab), I have to fire a “Mouse Over” event on the tabs themselves to get the screen to update to show that a new tab is active.
    When the active tab is not showing as active, it is a bit confusing to know what you’re looking at on the screen.
    This may be an issue only when several tabs are open, and when the application has been running for some time. Not sure about those two points.
    I’ll stop there. If you need further clarification just let me know.
    Thanks,
    Mike Kemp

    • thatjeffsmith

      reproduce it on 21.2 and let me know if it’s still a thing…you do that, I’ll file the bug for you 🙂

  10. Avatar

    Hello,
    I’m trying to use sqlcl instead of SQL*Plus and having relative success on this attempt.
    Except for the fact that when I paste code that has CRLF line endings, sqlcl adds an extra new line.
    I know that if I use a text editor to convert text to LF it works.
    Is there any way to make it work without this extra step? i.e. to paste text that has CRLF as line endings directly to sqlcl and have it not adding extra lines between them?
    Regards!

    • thatjeffsmith

      we had an issue with extra line breaks in a recent release, but i’m not able to reproduce this in 21.3 which is due to go our SHORTLY. What version are you using?

Write A Comment

RSS
Follow by Email
LinkedIn
Share