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,165 Comments

  1. Hi Jeff …
    Could you please help us with a question/dubt? we are executing a query through the sqlcl againt a database with NLS_LANG=WE8ISO8859P1 and we have the error : java.io.UnsupportedEncodingException: WE8ISO8859P1
    Can we by pass this error or the sqlcl it’s not ready for all NLS_LANG existent

  2. Hey Jeff – very informative blog!

    Quick question though – is there a Go-to Column shortcut with SQL developer, similar to how we have Go-to Line(Ctrl + G)?

    Thanks!

  3. Hi Jeff,

    I am back to you to ask for feature I already asked in other threads and I apologize if I bother you but it is IMHO really important to use a separate (read only) connection for the SQLDev tasks. When one opens the “main” connection/session to a database that connection is used by SQLDev to fetch the metadata needed to show the database objects to the user. The same session may be tied to the editor and used to launch queries or compile packages. While a query tied to that session is in execution it is not possible, e.g., to open the tree containing the views in the chosen main session schema. All the sessions related to a particular connection should be not shared to avoid that the interactions between two editors tied to the same session will cause potentially evil outcomes.

    Moreover it is really important to allow to tie a previously saved file to an unshared sessions.

    BTW. The sql-plsql formatter still does not work well. I pointed out the problems the formatter has years ago (maybe in version 3), and , although improved since then, its behavior is still not good so that I sometimes go to sites like “instant sql formatter” to get a layout good enough to do plsql source code comparisons.

    • thatjeffsmith

      BTW. The sql-plsql formatter still does not work well. I pointed out the problems the formatter has years ago (maybe in version 3), and , although improved since then, its behavior is still not good

      Examples please.

  4. Hi Jeff,
    I am using SQL Dev 19.1.0.094 and when I log on to a very busy Prod database and try & use Real Time SQL Monitor (We have diag + tuning packs), I constantly get “No content in table”. This would not be possible on our database as there has always been something to look at. This worked fine in previous versions of SQL Dev. Am I missing something?
    Thanks
    Vic

    • thatjeffsmith

      if you look at the Statements panel in the Log, you can see what queries we’re running to make that screen work

  5. Patrick Rohan Reply

    Jeff:

    I use ver 17.3.1.279 and noticed that suddenly I can not see the window that contains the compiler log, which shows the compilation error messages. In the past I recall that if this happened I just clicked View – Log and it appeared, but that does not work now. I checked the Preferences, but can’t seem to find one that applies. Can you give me some suggestions please? Thank You.

    • thatjeffsmith

      that doesn’t usually appear until you actually have compiler errors/warnings

      you’re on 17.3, you could try upgrading to 19.1, or using Window > Reset Windows to Factory Settings

    • Patrick Rohan

      I DO have compiler errors. I will try the upgrade. Thanks.

    • Patrick Rohan

      “Reset Windows to Factory Settings” worked!
      Thanks.

  6. I have SQL Developer 19, but I want to use the sdcli interface. Have the docs, but it is unclear how to define a connection so I can execute SQL. I see the connect syntax, which is like in SQL*Plus. I don’t have a Oracle Client install and from the docs it isn’t required. Not having luck with web searches either.

    • thatjeffsmith

      there are two command line interfaces, sqlcl and sdcli

      you don’t use sdcli to execute queries, you use sqlcl

      to get started, open a terminal/cmd window, and run the SQL exe or .sh and do something like, sql hr/[email protected]

      then start using it just like you would with SQL*Plus

      i have lots of videos, slides, blog posts, etc here in addition to the docs that should answer your questions

      you don’t need an Oracle Cclient

  7. I sincerely would like to have a web-meeting with Jeff Smith concerning configuring SQL Developer on Mac OS X.

  8. Hello,
    I made an Rest-Call to receive max 150.000 records, but the answer is always limited to 10.000. Can i increase this limit somewhere ?

    My call is:

    http://xxxx/ords/a95/code?q={“$orderby”:{“fcode”:”ASC”}}&offset=0&limit=1500000

    Thanks for help
    Klaus

    • thatjeffsmith

      you need to make sure your module isn’t set to 10.000 but it’s more likely you have the max in your defaults.xml set to 10.000 – set it to 0 for unlimited

  9. Can you please provide (if any) the shortcut to open a view and see the SQL.

    I tried to use the SHIFT+F4 but it opens with no SQL tab.

    I actually have to go to the view and click on it to see the SQL tab so I can view the code.

    Thanks in advance

    Candy

  10. Hi

    I am trying to install SQLDev 19.1 on Solaris 10. Is this possible? I get an error message when running sqldeveloper.sh

    Could not find the main class: oracle.ide.osgi.boot.OracleIdeLauncher

    I downloaded the Other platform release

    • thatjeffsmith

      The main requirement for Oracle SQL Developer is that you have access to a supported and working Oracle JDK 8 home on your machine.

      First thing I would try is removing the folder, re-extract the Zip to a fresh directory, and try running it again.

  11. Lee Mezzulo Reply

    Hello Jeff, Thank you for creating the website and instruction. I was wondering , I am trying to use the query builder with the HR DB when you mentioned to crap the tables for a drag and drop but when I am doing that nothing is populating in the worksheet. Possibly any ideas? Thank you for your time. I am appreciative.

    • thatjeffsmith

      >>when you mentioned to crap the tables for a drag and drop but when
      I’m going to guess you meant to say, ‘grab the tables for a drag and drop’…and you mention query builder AND the worksheet, are you dropping into the worksheet, or into the query builder?

      Either way you should be getting something. What exactly do you see when you do the drop? Any messages in the Log panel (errors)?

  12. In TOAD, you could create a script in the correct order to create a table and indexes etc. Is there a function in SQL Developer that does all that? We’re moving people from TOAD to SQL Developer and the devs are complaining that the scripts aren’t working because they don’t create the table. Maybe we’re missing an option to include table creation in the script. The way they are doing it is going to the table, and clicking the SQL tab.

    • Hi Jeff,

      More information:

      TOAD for Oracle creates this script:

      *** START OF TOAD SCRIPT ***

      CREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE
      (
      DOMAIN_KEY NUMBER NOT NULL,
      DWS_ATTRIBUTE_KEY NUMBER NOT NULL,
      DOMAIN_NME VARCHAR2(100 BYTE) NOT NULL,
      ATTRIBUTE_NME VARCHAR2(30 BYTE) NOT NULL
      )
      TABLESPACE DD_DATA_01
      PCTUSED 0
      PCTFREE 10
      INITRANS 1
      MAXTRANS 255
      STORAGE (
      INITIAL 64K
      NEXT 64K
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      LOGGING
      NOCOMPRESS
      NOCACHE
      NOPARALLEL
      MONITORING;

      CREATE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_I1 ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE
      (DWS_ATTRIBUTE_KEY)
      LOGGING
      TABLESPACE DD_INDX_01
      PCTFREE 10
      INITRANS 2
      MAXTRANS 255
      STORAGE (
      INITIAL 64K
      NEXT 64K
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      NOPARALLEL;

      CREATE UNIQUE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_UI ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE
      (DOMAIN_KEY, DWS_ATTRIBUTE_KEY)
      LOGGING
      TABLESPACE DD_INDX_01
      PCTFREE 10
      INITRANS 2
      MAXTRANS 255
      STORAGE (
      INITIAL 64K
      NEXT 64K
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      NOPARALLEL;

      CREATE OR REPLACE PUBLIC SYNONYM DDMV_DOMAIN_ATTRIBUTE FOR ADM_DD.DDMV_DOMAIN_ATTRIBUTE;

      GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_DBA;

      GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_DESIGN;

      GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_FORM_ADMIN;

      GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_VIEW;

      GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO PUBLIC;

      *** END OF TOAD SCRIPT ***

      Note that TOAD script has the create table first, then index creation after.

      View the SQL Developer (latest version) script, visible from the SQL tab, or created via Create DDL right-click option:

      *** START OF SQL DEVELOPER SCRIPT ***

      — Unable to render TABLE DDL for object ADM_DD.DDMV_DOMAIN_ATTRIBUTE with DBMS_METADATA attempting internal generator.
      CREATE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_I1 ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE (DWS_ATTRIBUTE_KEY ASC)
      LOGGING
      TABLESPACE DD_INDX_01
      PCTFREE 10
      INITRANS 2
      STORAGE
      (
      INITIAL 65536
      NEXT 65536
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      NOPARALLEL
      CREATE UNIQUE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_UI ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE (DOMAIN_KEY ASC, DWS_ATTRIBUTE_KEY ASC)
      LOGGING
      TABLESPACE DD_INDX_01
      PCTFREE 10
      INITRANS 2
      STORAGE
      (
      INITIAL 65536
      NEXT 65536
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      NOPARALLELCREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE
      (
      DOMAIN_KEY NUMBER NOT NULL
      , DWS_ATTRIBUTE_KEY NUMBER NOT NULL
      , DOMAIN_NME VARCHAR2(100 BYTE) NOT NULL
      , ATTRIBUTE_NME VARCHAR2(30 BYTE) NOT NULL
      )
      LOGGING
      TABLESPACE DD_DATA_01
      PCTFREE 10
      INITRANS 1
      STORAGE
      (
      INITIAL 65536
      NEXT 65536
      MINEXTENTS 1
      MAXEXTENTS UNLIMITED
      PCTINCREASE 0
      BUFFER_POOL DEFAULT
      )
      NOCOMPRESS
      NOPARALLEL

      *** END OF SQL DEVELOPER SCRIPT ***

      Note inthe SQL Developer-generated script, create index is the first entry in the script.

      How do we get SQL Developer to create a script to create the table, then the indexes, so that SQL Developer can run the script without errors.

      Note: that we are getting this error: — Unable to render TABLE DDL for object ADM_DD.DDMV_DOMAIN_ATTRIBUTE with DBMS_METADATA attempting internal generator.

      TOAD doesn’t give any errors like that.. is SQL Developer more picky when it comes to permissions?

      We also noticed that there is no space in “NOPARALLELCREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE”, which appears to be an error.

      Thanks for your engagement with the community – it really does make a difference!

    • thatjeffsmith

      Toad doesn’t use dbms metadata to generate ddl, we do

      You need fairly high privs for that package, check the DB docs for details

  13. vishal grover Reply

    How the life of PL/SQL developer changes after the things start moving from on-premises to cloud? What are all tools we need and environment etc?

    • Thanks Jeff. Presumably Oracle uses DBMS metadata to generate DDL as that’s more reliable?

    • thatjeffsmith

      Yes, we’re asking the database for the DDL. So you get what the database says it is. Your tool has some queries that mine the data dictionary, and it builds the DDL from that.

  14. Peter Cunningham Reply

    Hi Jeff,

    getting below on Sql Developer 19.1 when attempting to export query results/tables/user defined report results.
    Is it occurring for you?

    Thanks,
    Peter.

    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
    at oracle.ide.wizard.Step.newTraversable(Step.java:171)
    at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
    at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)
    at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)
    at oracle.ide.wizard.FSMWizard.(FSMWizard.java:121)
    at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
    at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
    at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)
    at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:168)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
    at java.awt.Component.processMouseEvent(Component.java:6539)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    at java.awt.Component.processEvent(Component.java:6304)
    at java.awt.Container.processEvent(Container.java:2239)
    at java.awt.Component.dispatchEventImpl(Component.java:4889)
    at java.awt.Container.dispatchEventImpl(Container.java:2297)
    at java.awt.Component.dispatchEvent(Component.java:4711)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
    at java.awt.Container.dispatchEventImpl(Container.java:2283)
    at java.awt.Window.dispatchEventImpl(Window.java:2746)
    at java.awt.Component.dispatchEvent(Component.java:4711)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
    at java.awt.EventQueue.access$500(EventQueue.java:97)
    at java.awt.EventQueue$3.run(EventQueue.java:709)
    at java.awt.EventQueue$3.run(EventQueue.java:703)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
    at java.awt.EventQueue$4.run(EventQueue.java:733)
    at java.awt.EventQueue$4.run(EventQueue.java:731)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
    at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
    at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
    Caused by: java.lang.IllegalArgumentException: URI has an authority component
    at java.io.File.(File.java:423)
    at oracle.dbtools.raptor.ui.URLFileChooser.toFile(URLFileChooser.java:402)
    at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1572)
    at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1541)
    at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1619)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:130)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:114)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:110)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:106)
    at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.(URLFileChooser.java:862)
    at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:822)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:274)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:64)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:56)
    at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.(ExportWizDestinstaionPanel.java:105)
    … 54 more
    java.lang.IllegalArgumentException: URI has an authority component
    at java.io.File.(File.java:423)
    at oracle.dbtools.raptor.ui.URLFileChooser.toFile(URLFileChooser.java:402)
    at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1572)
    at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1541)
    at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1619)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:130)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:114)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:110)
    at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:106)
    at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.(URLFileChooser.java:862)
    at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:822)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:274)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:64)
    at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:56)
    at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.(ExportWizDestinstaionPanel.java:105)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
    at oracle.ide.wizard.Step.newTraversable(Step.java:171)
    at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
    at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)
    at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)
    at oracle.ide.wizard.FSMWizard.(FSMWizard.java:121)
    at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
    at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
    at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)
    at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:168)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
    at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
    at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
    at java.awt.Component.processMouseEvent(Component.java:6539)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    at java.awt.Component.processEvent(Component.java:6304)
    at java.awt.Container.processEvent(Container.java:2239)
    at java.awt.Component.dispatchEventImpl(Component.java:4889)
    at java.awt.Container.dispatchEventImpl(Container.java:2297)
    at java.awt.Component.dispatchEvent(Component.java:4711)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
    at java.awt.Container.dispatchEventImpl(Container.java:2283)
    at java.awt.Window.dispatchEventImpl(Window.java:2746)
    at java.awt.Component.dispatchEvent(Component.java:4711)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
    at java.awt.EventQueue.access$500(EventQueue.java:97)
    at java.awt.EventQueue$3.run(EventQueue.java:709)
    at java.awt.EventQueue$3.run(EventQueue.java:703)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
    at java.awt.EventQueue$4.run(EventQueue.java:733)
    at java.awt.EventQueue$4.run(EventQueue.java:731)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
    at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
    at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

    • thatjeffsmith

      Occurring when, after you click OK on the export dialog or before it even opens?

      And no, this is working for me.

    • Peter Cunningham

      As soon as I click “Export…” the Export Wizard – Step 1 of 2 appears with Source/Destination highlighted on the left and “Internal Error when attempting to create this panel:” and Java log on the right.

    • thatjeffsmith

      do you have network drives mapped? that error says there’s a URL it’s finding and not liking

    • Peter Cunningham

      Hi Jeff,
      got it fixed.
      18.4 had “Use Oracle Client” not ticked but the field underneath was populated i.e. Oracle Home: file:/C:/……..etc as it doesn’t clear when Use Oracle Client is unticked.
      Seems to cause an issue in migration to 19.1. When I tick “Use Oracle Client” in 18.4 and re-install 19.1 (migrating settings from 18.4) the export is now working!
      Thanks,
      Peter.

  15. Hi Jeff,
    I’m running sql developer with it’s included java.
    sql datamodeler can be used pointing to the jdk folder in sql developer download.

    I would like to run SQLcl in the same way because I’d like to avoid a full java installation as its shown on startup of SQLcl.

    Is this possible? Yes? Please provide a short explanation.

    Thx,

    Dirk
    is it possible to use SQLcl with the java

    • thatjeffsmith

      sqlcl doesn’t need a full jdk, just a JRE, so if your machine already had java 11 already, should be good

      but to answer your question, yes. you just need to update the path on your machine to point to the jdk home in the sqldev folder, so your machine has access to it

      that’ll open up your entire machine to Java programs though, not just SQLcl

    • thatjeffsmith

      open Service Requests with My Oracle Support

      our developers try to monitor the forums, but there’s no contract in place for us to treat the forums as an official support channel

      i’ll go take a look at those threads though

  16. Douglas Robertson Reply

    Hi Jeff,
    I’m using sql developer 4.2.0. I have set max char line width to 100. When I paste sql into editor with select line longer than 100 and click “Ctrl + F7” nothing is happening. I have On comma set to after. Can you help with formatting SQL?

  17. When we install a new version of SQL Developer, we have to set locale to US, it should be Faroese, FO, otherwise we get an error message: Locale not recognized. Vendor code 17176.
    Workaround is to set locale:
    AddVMOption -Duser.language=en
    AddVMOption -Duser.region=US
    and that is not the best solution.
    Is there any chance, it will be fixed?

  18. Leonardo Wolo Reply

    Hello
    I need to create a project for school with SQL developer but I’m only a beginner.
    I have a part of my code but keep getting an error message which causes some tables to not be created.
    This is my code:

    CREATE TABLE speler(
    spelerID INT CONSTRAINT speler_pk PRIMARY KEY,
    ploegID INT NOT NULL,
    spelernaam VARCHAR2(50 CHAR),
    rugnummer INT,
    positieID INT,
    FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID),
    FOREIGN KEY (positieID) REFERENCES positie(positieID)
    );

    CREATE TABLE spelerPositie(
    positieID INT CONSTRAINT positie_pk PRIMARY KEY,
    positie VARCHAR2(50 CHAR)
    );

    CREATE TABLE ploeg(
    ploegID INT CONSTRAINT ploeg_pk PRIMARY KEY,
    ploegnaam VARCHAR2(50 CHAR)
    );

    CREATE TABLE spelerWedstrijdspeler(
    wedstrijdID INT NOT NULL,
    spelerID INT NOT NULL,
    FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
    FOREIGN KEY (wedsrijdID) REFERENCES wedstrijd(wedstrijdID)
    );

    CREATE TABLE spelerWedstrijd(
    wedstrijdID INT NOT NULL,
    spelerID INT NOT NULL,
    ploegID INT NOT NULL,
    doelpunten INT,
    FOREIGN KEY (wedstrijdID) REFERENCES wedstijd(wedstrijdID),
    FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
    FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID)
    );

    CREATE TABLE wedstrijd(
    wedstrijdID INT CONSTRAINT wedstrijd_pk PRIMARY KEY,
    thuisploeg VARCHAR2(50 CHAR) NOT NULL,
    uitploeg VARCHAR2(50 CHAR) NOT NULL,
    competitieID INT NOT NULL,
    wedstrijd_datum DATE NOT NULL,
    wedstrijd_tijd TIMESTAMP NOT NULL,
    FOREIGN KEY (competitieID) REFERENCES competitie(competitieID)
    );

    CREATE TABLE wedstijdCompetitie(
    competitieID INT NOT NULL,
    wedstrijdID INT NOT NULL,
    FOREIGN KEY (competitieID) REFERENCES competitie(competitieID),
    FOREIGN KEY (wedstrijdID) REFERENCES wedstrijd(wedstrijdID)
    );

    CREATE TABLE competitie(
    competitieID INT CONSTRAINT competitie_pk PRIMARY KEY,
    competitienaam VARCHAR2(50 CHAR)
    );

    And this or my errors:

    Error starting at line : 2 in command –
    CREATE TABLE speler(
    spelerID INT CONSTRAINT speler_pk PRIMARY KEY,
    ploegID INT NOT NULL,
    spelernaam VARCHAR2(50 CHAR),
    rugnummer INT,
    positieID INT,
    FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID),
    FOREIGN KEY (positieID) REFERENCES positie(positieID)
    )
    Error report –
    ORA-00942: table or view does not exist
    00942. 00000 – “table or view does not exist”
    *Cause:
    *Action:

    Error starting at line : 12 in command –
    CREATE TABLE spelerPositie(
    positieID INT CONSTRAINT positie_pk PRIMARY KEY,
    positie VARCHAR2(50 CHAR)
    )
    Error report –
    ORA-00955: name is already used by an existing object
    00955. 00000 – “name is already used by an existing object”
    *Cause:
    *Action:

    Error starting at line : 17 in command –
    CREATE TABLE ploeg(
    ploegID INT CONSTRAINT ploeg_pk PRIMARY KEY,
    ploegnaam VARCHAR2(50 CHAR)
    )
    Error report –
    ORA-00955: name is already used by an existing object
    00955. 00000 – “name is already used by an existing object”
    *Cause:
    *Action:

    Error starting at line : 22 in command –
    CREATE TABLE spelerWedstrijdspeler(
    wedstrijdID INT NOT NULL,
    spelerID INT NOT NULL,
    FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
    FOREIGN KEY (wedsrijdID) REFERENCES wedstrijd(wedstrijdID)
    )
    Error report –
    ORA-00904: “WEDSRIJDID”: invalid identifier
    00904. 00000 – “%s: invalid identifier”
    *Cause:
    *Action:

    Error starting at line : 29 in command –
    CREATE TABLE spelerWedstrijd(
    wedstrijdID INT NOT NULL,
    spelerID INT NOT NULL,
    ploegID INT NOT NULL,
    doelpunten INT,
    FOREIGN KEY (wedstrijdID) REFERENCES wedstijd(wedstrijdID),
    FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
    FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID)
    )
    Error report –
    ORA-00942: table or view does not exist
    00942. 00000 – “table or view does not exist”
    *Cause:
    *Action:

    Error starting at line : 39 in command –
    CREATE TABLE wedstrijd(
    wedstrijdID INT CONSTRAINT wedstrijd_pk PRIMARY KEY,
    thuisploeg VARCHAR2(50 CHAR) NOT NULL,
    uitploeg VARCHAR2(50 CHAR) NOT NULL,
    competitieID INT NOT NULL,
    wedstrijd_datum DATE NOT NULL,
    wedstrijd_tijd TIMESTAMP NOT NULL,
    FOREIGN KEY (competitieID) REFERENCES competitie(competitieID)
    )
    Error report –
    ORA-00955: name is already used by an existing object
    00955. 00000 – “name is already used by an existing object”
    *Cause:
    *Action:

    Error starting at line : 49 in command –
    CREATE TABLE wedstijdCompetitie(
    competitieID INT NOT NULL,
    wedstrijdID INT NOT NULL,
    FOREIGN KEY (competitieID) REFERENCES competitie(competitieID),
    FOREIGN KEY (wedstrijdID) REFERENCES wedstrijd(wedstrijdID)
    )
    Error report –
    ORA-00955: name is already used by an existing object
    00955. 00000 – “name is already used by an existing object”
    *Cause:
    *Action:

    Error starting at line : 56 in command –
    CREATE TABLE competitie(
    competitieID INT CONSTRAINT competitie_pk PRIMARY KEY,
    competitienaam VARCHAR2(50 CHAR)
    )
    Error report –
    ORA-00955: name is already used by an existing object
    00955. 00000 – “name is already used by an existing object”
    *Cause:
    *Action:

    Hopefully someone can help. Thank you.

    • thatjeffsmith

      I generally don’t have time to help with SQL or schema design questions, you should post this to StackOverflow, and hope your professor doesn’t mind.

  19. Daniel Looby Reply

    I go into Excel, create a new spreadsheet and save the spreadsheet to my desktop. Then I go into Outlook, create a new email and when I click on ‘Attach File’ the newly created spreadsheet is at the top of ‘Recent Items’ and with one more click is attached to the email.

    I write a query in a worksheet in SQL*Developer, get the results and then export the data in ‘excel 2003+ (.xlsx)’ format to my desktop. Then in Outlook I create a new email and click on ‘Attach File’. The newly created spreadsheet is not listed. I have to ‘Browse This PC’, click a location, maybe an additional sub-directory, find the file in the listing, click the file to get it in the ‘Open’ line and then click ‘Open’. Can the SQL*Developer Export option not add items to the same list that Microsoft uses to make the file selection less painful?

    Dan

    • thatjeffsmith

      No, we can’t. We don’t have access to the windows/office APIs like a native msft app does.

      What I do to avoid this pain, is i copy the filename (with) path while I’m in the Export dialog, so I can just paste it into explorer to open it, or attach to an email.

    • Daniel Looby

      Jeff,

      I also use a product name Snagit (from TechSmith) to get screen shots for articles and document things. When I take a snapshot of something and save it and then go into Outlook, open a new email and go to ‘Attach File’ there at the top of the list is the snapshot I took with Snagit. I can do the same with Notepad++, which is not a Microsoft product. So it would seem to be a generally available API for such.

    • thatjeffsmith

      those aren’t java applications, find me a java app that does that, and then i can go poke around to see how they did it

  20. Michael Farren Reply

    Hi Jeff,

    Really appreciate the great content you publish in relation to the various products that you manage, thanks for this.

    I’ve been looking into the possibility of automating the generation of pdf output from a SQL query. As a result, I was wondering if there was a way to use the SQLcl tool to run an User Defined Report (UDR) set up in SQL Developer to output results in a pdf format?

    From reading some of your posts I believe it’s possible to format & export the output from an UDR within SQL Developer as pdf but was hoping to remove the manual intervention from this process, which is where I considered the SQLcl tool. It looks like the ALIAS option is available to easily define and run the source SQL from an UDR and i’m sure if i needed the output as CSV, JSON etc this would be ideal, but i’m unsure if this process could be used to output to pdf? Or is there a better way to do this type of thing using Oracle products (ORDS, APEX etc)?

    Thanks,
    Michael

    • thatjeffsmith

      I see it most when SQL Dev shuts down…abruptly.

      This should fix it, Window > Reset to Factory

  21. Keith Bines Reply

    In the “other users” filter I want to include an underscore as a character in the filter. In sql i can do
    LIKE ‘XX\_%’ ESCAPE ‘\’ to escape the _. How can I achieve the same in sqldeveloper filters?

  22. Hi Jeff,

    In order to connect to the database, ORDS requires entry of the database’s hostname, port, and servicename or sid into the ords_params.properties file. This works fine, but does not comply with our enterprise standard of using OID (Oracle Internet Directory) to lookup the database connection details. For our applications that use the “thick” Oracle client, we have a SQLNET.ORA and LDAP.ORA file configured that points to our OID server. And for our Java applications, we use the JDBC “thin” Oracle client and just specify the JDBC connect string as follows:

    jdbc:oracle:thin:@ldap://oid.company.com:3060/cn=OracleContext,dc=Company,dc=com/mydbservice

    How can we make ORDS use a JDBC connection string?

    Thanks,
    Jack Wells

  23. Jenny Esteves Reply

    Hi Jeff, I deployed ords.war with tomcat. I was testing the url (localhost:port/ords), and is success, but when I selected SQLWorkshop->RESTFulServices->Oracle.example.hr->empinfo->GET and Button TEST doesn’t appear.

    I just validate ords.war and was success. The APEX_LISTENER , APEX_LISTENER_USER exists and are OPEN status.

    Could you help me with that. Thanks

    Regards
    Jenny

  24. Appreciate your site and have a question.

    Just stepping into a new job and back into Oracle/Java arena. The team is diverse and though coding standards exist, timelines and deliverables have overridden a good portion of the codebase.

    I want to write an “addin” to SQL Developer that enforces the coding standards (file naming, object format + name, etc) and integrate it to SQL Developer.

    Can you point me in the right direction?

Write A Comment