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!

5,734 Comments

  1. Hi Jeff,
    I post this question to you because it has been a month & I still can’t get sqldeveloper 19.2 to work on macbook pro ( Mojave )
    SQLDeveloper work for a while & then connection freezes and the ‘run icons’ in sqlwork sheets become grey.
    Javdetails are : –
    java version “11.0.7” 2020-04-14 LTS
    Java(TM) SE Runtime Environment 18.9 (build 11.0.7+8-LTS)
    Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.7+8-LTS, mixed mode)

    Hopefully it’s some small tweak that need to be done.
    Best,
    ~kS

  2. Hello Jeff,

    We are upgrading our ORDS infrastructure and we have setup an apache httpd server for serving the APEX static resources. The idea is to use this server for all our environments, so it will be used from different URLs, apex.mydomain.com, devapex.mydomain.com, etc… Trouble is that when we switch from URLs we are getting

    Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://apex-static.mydomain.com/apex_image/apex_images1820/app_ui/font/apex-5-icon-font.woff2. (Reason: CORS header ‘Access-Control-Allow-Origin’ does not match ‘https://apex.mydomain.com’)

    In the apache conf we have something like this:

    SetEnvIf Origin “http(s)?://(.*.mydomain.com)$” AccessControlAllowOrigin=$
    Header add Access-Control-Allow-Origin %{AccessControlAllowOrigin}e env=AccessControlAllowOrigin
    Header merge Vary Origin

    This should help the browsers to create a cache key per object and URL, but it seems that is not working as we expected, probably we are missing something…

    We are thinking in “relax” the configuration and use “*” in the “Access-Control-Allow-Origin”, like static.oracle.com [1].

    Any thoughts on this?

    Thank you very much in advance,

    Luis

    [1] https://blogs.oracle.com/apex/announcing-oracle-apex-static-resources-on-oracle-content-delivery-network

  3. I am trying to use Oracel REST using SQL Developer. I created 3 tables and enabled them for the REST. The URL allows me to use them in browser. However, when i try to create user defined functions in REST DEVELOPMENT under same schema, it is throwing 404 error. I am wondering what is wrong here.

    Thanks in advance.

    • thatjeffsmith

      In your connection tree, you can REST enable a function by right click…or in the REST Services tree section you can create a new module, template, GET/POST handler to exec your function.

      Where exactly are you getting a 404? What step/url?

  4. Amin Adatia Reply

    v19.4
    Database 19.3
    How do I activate “Invoke Map View for Result Set”

    • thatjeffsmith

      View > Map View

      This will activate the Spatial plugin/feature, then the grids should have the Map View context menu available.

    • Amin Adatia

      Is there a way to then plot the points on polygons onto an actual map of the world? I am trying to mark areas of fishing

  5. Hi Jeff, Love the work you are doing.
    I have a stupid question. Is there a way to search for a constraint by name in sql developer? One of the most frequent errors I see is ORA-00001: unique constraint (BLA-BLA) violated, or some other constraint violated.

    First step is to determine what table(s) are referred to by the constraint. Is there a way to find the tables involved without running a query against all_constraints? Sometimes a few month go by and I don’t remember the exact syntax and then have to look it up and it takes 10 minutes to find because I am easily distracted. A search in sql developer should take me 2 seconds if it is available. I tried the search for all objects but this does not find constraints.

    I would be grateful for any ideas you may have.

    Kind regards,
    André

    • Oops, I realise what my problem was. In the “Find Database Objects” widget, I did not have the correct schema selected. I was able to find the constraint now without having to write some sql.

      Only thing I can suggest is if someone can add the ability to favourite or default to a certain schema, it is a pain to do the same thing each time I use the tool.

    • Amin Adatia

      Is it possible to also show the points on an actual Map?

    • thatjeffsmith

      Yes, but I’m not the right person to ask. My knowledge of Spatial is limited to what I can get to pop out of the Docs. I would recommend you reach out to David Lapp.

Write A Comment