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

  1. Avatar

    First, let me thank you for your awesome site; I refer to it a lot.

    In the SQL Developer Version 4.1.1.19, there are two or three line breaks after each line in the Script Output; here’s what I mean:
    http://snag.gy/IhgUw.jpg

    In the previous version I used (I don’t remember the version number now, but it was 4.x), there was only one line break. How do I change the line breaks back to the previous setting to have more compact Script Output?

    I would appreciate any help you could give here; I’ve been scoring through options and I’ve searched your site up and down, and could find anything on this.

    • thatjeffsmith

      I’m on vacation this week, but am trying to answer questions as I can…I believe we made the change to intentionally mimic SQL*Plus behavior, so check your SET commands to get the output as you want, and then feed those to a login.sql script you define in the preferences to run automatically at connect time

    • Avatar

      * “so check your SET commands to get the output as you want”: Sorry, but I don’t really understand what you’re talking about here. Do you have a blog post with the necessary details, or could you please clarify?

      * “feed those to a login.sql script you define in the preferences to run automatically at connect time”: I assume you are referring to what you explained in http://www.thatjeffsmith.com/archive/2015/05/how-to-format-your-script-output-in-sql-developer-by-default/; I could do that if I know what setting I’m trying to adjust.

      I did run the “show all” command, but none of the settings I see displayed seems obviously related to what I’m looking for.

    • Avatar

      Sorry, but that link goes to an unresolved question, and the answer offered doesn’t help at all. Do you know the option I should be looking for to remove line breaks in the Script Output?

  2. Avatar

    Hi Jeff, I’m experiencing a fairly rare, but ennoying problem.
    I create a new table by using an instruction like this:
    CREATE TABLE new_tab AS
    SELECT *
    FROM a_view;
    After that, if I try to modify the data using the Data View (of the new_tab table) I cannot do that, the insert new row button is greyed (disabled), and any direct modification of the data is disabled.
    However, I can modify the data by using normal SQL instructions (INSERT, UPDATe and DELETE) in the worksheet.
    If I rerun a CTAS statement on the new_tab table, e.g.
    CREATE TABLE new_tab2 AS
    SELECT *
    FROM new_tab;
    the table new_tab2 can instead be modified without problems.
    The issue seems to be related to “copies” of views (possibly materialized).
    Any suggestion/tip for that? Should I open a SR for that?
    SQL Developer version 4.1.0.18
    Oracle DBMS version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

  3. Avatar

    Yeah, that’s what I was thinking, but I have no clue what it could be, any ideas?

  4. Avatar

    OK, I was able to get past the startup hanging at 4 segments of the progress bar. I did that by copying my appsdata\roaming\SQL Developer folder from another system where the install worked.
    Now, it comes up, but I don’t have a workspace window and under the “File” menu there is no option to “Create connection”

    • thatjeffsmith

      did we cover you running it as an Administrator yet? windows permissions or application security getting in the way is my last guess

    • Avatar

      I am running it as administrator, I suspect you may be right about the security issue, unfortunately the systems are being administered by a third party. I will check with them.

  5. Avatar

    Hi Jeff,
    I have been using SQLDeveloper for a while. And basically, it is my main tool when it comes to DB development.
    But it needs an improvements to become the tool of choice and I think the improvements should be:
    1. The code formatting is not consistent . e.g. When I use merge statement it does not recognize when not matched case as SQL keyword.
    2. Not flexible, as when it comes to me I would like to have table names lowercase and keywords uppercase. This does not allow me to do so.
    Basically, instead of making changes case by case, it would be more efficient if some designer work would be done beforehand. It seems that it is missing overall idea when it comes to formatting.

    • thatjeffsmith

      For #2, you can def do that.

      Two ways even. As you type…

      Or set your formatting options to Other > Case Change > ‘Keywords Uppercase’

      For #1, can I have an example?

      FWIW, we’re updating the parser/formatter we use in the next version and it should be much more consistent on the advanced SQL statements.

      So, it’s your main tool, but not your tool of choice?

      What else do we need to do to win you over?

    • Avatar

      Our developers use PL/SQL Developer, it has many formatting features. SQL Developer formatting and code assistance parts need to be improved so the developers could switch to SQL Developer. Until now we have not seen much improvements in above areas, hopefully the next release will be different. As you understand, usually 20% of the features of the tool are used, but people use it as main tool if they are quite satisfied with these 20% of features.

    • thatjeffsmith

      the formatter is undergoing a big facelift for the next version

      i don’t see any issues with the code assistance parts though – can you elaborate?

    • thatjeffsmith

      Try SQLcl – works great. Only 12MB, tons of features. I talk about it here on my blog, a lot.

  6. Avatar

    I have install sqldeveloper 4.1(64bit) on Windows Server 2008 R2(64bit).
    Installed java jdk1.8.0_45 and have pointed the SqlDeveloper to this jdk.
    When starting sqldeveloper64W.exe, I get the load screen, the bar makes it about 10% of the way across and the whole process just dies. No error msgs, nothing. I did notice that in my appdata\roaming folder for sqldeveloper that a “lock” file is being created. Any help is appreciated, I have done this onstall on 3 other systems(same OS) with no problem. Thanks!

    • Avatar

      Did that, same thing – it’s still creating the lock file

    • Avatar

      What the lock file? I dbl click sqldeveloper64W.exe, I get the load screen with the progress bar. The progress bar makes it about 10% of the way across and the process dies(watching it in Task Mgr).

    • Avatar

      Under C:…\AppData\Roaming, I deleted two folders:
      SQL Developer and sqldeveloper. Under “SQL Developer” I have a folder named “system4.1.0.19.07”, under that: “dropins_support” and “system_cache”, “system_cache is where the “lock” file is being created.

      Under sqldeveloper there is one folder “4.1.0” it contains the “product.conf” file which is pointing to my jdk (jdk1.8.0_45)

  7. Avatar

    Hi Jeff, great site by the way. Do you know if there is a way to display your queries in record view ? I know that if you right click on Query Result there is an option for “Single Record View” but you can’t copy /paste that and you can only do one at a time.

    In postgresql, you can turn on what they call “expanded table output” with a \x in the cli.

    I’m looking to display my queries like this:

    ID 123
    NAME test
    VERSION 4

    Instead of:

    ID NAME VERSION
    123 test 4

    Regards,
    Joe

  8. Avatar
    Khadim Ali Reply

    Hi,
    Is it possible to export tables, indexes and constraints as one file per table. I have tried to export but SQL Developer creates one file each for tables, indexes and constraints.

    Thanks

  9. Avatar

    Hello Jeff

    Are there any options to arrange the Tables in the Query Builder automatically?

    Everytime when i build an query i have to drag and drop manually this is getting on my nerves.

    regards john s.

    • thatjeffsmith

      Sorry, arrange how? Are you using the ‘diagrams’ for something other than to write a query?

      The Query Builder doesn’t get a lot of enhancements as it’s a 3rd party component that we license to use. It’s also meant to be a ‘helper’ for new users as they get used to writing SQL by hand.

  10. Avatar

    Hi,

    Are there hash files for the SQL Developer download file? If so, how do I obtain one?

    Thanks.

  11. Avatar
    Steve Wallace Reply

    Hi Jeff,
    Why is it so hard to set some simple Script Output options? The default behavior is almost unusable. I just want a nice dump of rows, similar to the grid in Run Statement but plain text is OK. Just print the headers across the top and dump the records down below. Nothing fancy. That should be the DEFAULT. But I can’t even find an option to do that, without learning yet another “simple script language” to do it. This should be located at the same place where the default line limit of 5,000 is located.

    I obviously figured this out a few years ago with a previous version, but I forgot how, and now that I’ve upgraded, I can’t really use the tool the way I want.

    I’ve read all the official docs, searched your site and many others, and found nothing but Scripting. Again, this seems like very basic stuff, why is it so hard to do?

    Thanks,

    STEVE

    • Avatar
      Steve Wallace

      Hi Jeff,

      That is NOT what I consider easy. It is a GUI. For the very basic stuff there should be a few check-boxes. All kinds of arcane specialist stuff is available to select from the GUI, so why not the simplest thing of all?

      Also, why is badly formatted data the default? Why not make it like the grid?

      Sorry, but I’m NOT a dedicated Oracle DBA who grew up with the tool. I wear many hats and use many tools every day, and DBA is actually down the list. I want simple and easy tools, and this seems a little rough for something with so many updates. I’m in SQL Management Studio more often than Developer, and even though it’s more recent than Developer it is easier to use for the casual user.

      I think I should be able to right-click on the tab and make some basic output decisions. This works for many things in Developer, so why not for Query output?

      Sorry for the rant but it is a bit of a mystery to me why I have to waste so much time on something so basic.

      Steve

    • thatjeffsmith

      We went with SQL*Plus as the gold standard. So the defaults are matched up with what SQL*Plus does out of the box. There are dozens and dozens and dozens of settings we could put up on a preferences screen, so it’s a non-starter pretty much. Login.sql scripts are the de facto way of controlling this in the Oracle space.

      It takes a few minutes. Did you read my post I referenced before?

      To get the nice output by default, add this to your login.sql script
      set sqlformat ansiconsole

    • Avatar
      Steve Wallace

      Thanks for taking the time to listen to my rants. I did read your posts and I understand your points but it’s still frustrating to me, and not quite consistent.

      Somehow I have different behavior in 4.0.3.16 and in 1.5.5, with no startup scripts in any of them. No options different that I can see.

      I just fired up the 1.5.5 on a virgin workstation (it’s the default when we install JDE Enterprise One) and I get the “proper” Script Output.

      Regarding the “dozens and dozens”, you already do have hundreds and hundreds!

      Also, the ANSICONSOLE suggestion is not quite right, it puts commas in numeric fields where they are not wanted (Invoice #, Item #, etc). I just want the default that comes with the older versions without learning all the options that automagically got me there.

      But, never mind, I won’t waste any more of your time or mine, I will roll back to 4.0.3.16 and stay there.

      Thanks,

      STEVE

    • thatjeffsmith

      1.5.5 is from 2007 or ‘8. A lots changed since then. In fact, in version 4.1, we changed the SQL Developer script output to match SQL*Plus’s behavior so it would be more predicatable.

      People write their scripts in SQLDev and then run them in SQL*Plus. We want them to work in both places.

      We don’t have any preferences for script execution formatting that I know of, e.g. LINESIZE, ECHO, SPOOL.

      The ANSICONSOLE is configurable, you’ll see that in the next version of SQLDev, so you can omit the number formatting.

      You’re not wasting my time.

      Please keep up with the feedback.

    • Avatar
      Jeffrey Kemp

      FWIW – as a developer, the fact that SQL Developer mimics SQL*Plus behaviour is extremely convenient.

      Jeff S – when running individual queries you get a nice grid – perhaps a nice enhancement would be to allow running a script containing multiple SQL statements in one step – and have the result of each show up in a separate Results tab.

    • thatjeffsmith

      Actually you can. select the statements you want to run, hit ctrl+enter. All of the statements will run with result sets going to their own data grids.

  12. Avatar

    If a package is compiled by someone else while I’m connected to the same db, I find that I need to disconnect, then reconnect in order to ensure that we both have the same db state. The reconnect and refresh arrow buttons don’t seem to work well for this. I tend to land up with many many worksheet tabs at the end of the day with duplicate information (updating the connection for the worksheet is a bit slower, I tend not to use it often). Is there a more efficient way to remain in sync?

    • thatjeffsmith

      you have a file open or not?

      what version of SQLDev?

      reconnect and refresh won’t refresh the procedure editor source from the db, but if you close the editor and re-open it, it will

    • Avatar

      I’m just editing a package directly on the db using 4.1.2.20 64bit. I do find that the packages are not always updated with this method, for example sometimes if someone adds a package or recompiles a package in debug mode, I have to totally disconnect from the db and then reconnect to see the updated state.

      I guess what you are hinting at is to use files as a way to stay in sync with others rather than over the db? It would be cool to, but SQL developer does not support files with for example %23 in the filename, it parses it as #, then can’t find a file with the name # (the file is actually %23), so asks if I’d like a new one.

    • thatjeffsmith

      not hinting at using files – i was just wondering if files were in play

      opening and closing the editor should always refresh the code from the database – if it’s NOT doing that, it’s a SERIOUS bug. for now, i’m not able to reproduce it

  13. Avatar

    Jeff, I am having trouble with the latest version (4.1.2 64-bit) testing data returned via “IN OUT” parameters after an exception was thrown. My test is supposed to throw an exception. I also want to make sure the values returned by the “IN OUT” parameters are correct. However, I get strange results that don’t match the testing I do with an un-named PL/SQL block. It is as if the exception is causing the returned “IN OUT” values to be garbled when retrieved by the unit test software.

    • Avatar

      Jeff, I assume my unit test problem is too specific for the forum. Though I am heavily invested in the SQL Developer Unit Test Utility, I assume I need to find the needed functionality elsewhere. Many thanks for all you do with SQL Developer. I enjoy using the tool every day.

    • thatjeffsmith

      I don’t think so…but the forums isn’t just another place to talk to ‘me.’ It’s a community of the other users. And sometimes the developers hang out there.

      If you need to get an immediate response, you should be opening Service Requests with My Oracle Support.

      It was on my to-do list to check out your issue today, but holiday stuff got in the way. I’ll endeavor to try Monday.

      I’m assuming based on your awesome feedback that it’s a bug. And I WANT to say that I saw something similar get noted and fixed for a 4.1.3 patch that is due soon. But no promises.

  14. Avatar

    Cool blog. Thanks. I am having a weird problem with sql 4.0.2. I can’t open my .sql files if sql developer is open. I have done the simple things: open with from the context menu (windows) and associated tool: preferences: file types:open with sql but the files still won’t open. Anyone else with this issue?

    • thatjeffsmith

      Best advice I can give you right now is to try upgrading to v4.1.2 or reset your 4.0.2 settings.

      So File > Open in SQLDev won’t open the .sql file? Do you see anything written to the Log panel?

    • Avatar

      Jeff,

      I am working with 2 machines. The old client machine (Win 7 32 bit) with an older version of sql developer that is working great. The new client machine (Win 7 64 bit) with v4.0.2 with no user settings migrated. I would like to install v4.1.2 on the new client machine and use the preferences from the old client machine. I don’t know how to do this. Would I just grab the sql developer system folder out of app data>roaming?

    • thatjeffsmith

      ayup

      then then you start 4.1.2, it should see the 402 folder and ask if you want to copy the stuff over

    • Avatar

      Is there anyway to get sql developer to prompt me to copy stuff over? I have the folder in the App Data location but I don’t think it is associated with the new version yet. (low level stuff here but….)

    • thatjeffsmith

      shut down sqldev

      nuke the system4.1.2 folder in the App Data location on your new computer

      on your old computer, zip up the systemOLD version directory, and then extract that to the new computer

      start up sqldev, it will prompt to copy it over

    • Avatar

      The good news: the mechanics of copying over the folder worked as you suggested. I was prompted to migrate the older setting.

      The bad news: the original problem remains: The formatting preferences did not actually come over and .sql files will not open with sql developer if the application is already open. If I close the application, got to the file folder and click on a .sql file sql developer will open and display the file.

      This is a pretty weird problem.

      I guess a re installation is in order.

    • thatjeffsmith

      you can export/import the formatting preferences

      there’s something amiss in your settings if the .SQL issue is happening on both machines/installs, so nuke system4.1 folder and see if it STILL happens

    • Avatar
      julesdba

      Perhaps not what you are looking for, but I use symbolic links for SQL Developer and Modeler to keep my setting folder on a network drive. I have this setup from two locations – my laptop and a virtual desktop. I can work from either with the same settings. Also, my settings on the network are part of a more frequent backup.

  15. Avatar

    Hi Jeff,

    I use SQL Developer 4.1.2.20 and I’am currently testing the formatter concerning the automatic line break after -characters.

    e.g.:
    v_log_message_rollback := v_log_routine || v_log_my_name ||
    ‘ ROLLBACK performed !’;

    log.debug ( v_log_orgunit_code, v_log_context_code, v_log_module_code, v_log_my_name ) ;

    Is there any possibility to influence the indentation after an automatic line break ?
    I would prefer the following style:

    v_log_message_rollback := v_log_routine || v_log_my_name ||
    ‘ ROLLBACK performed !’;

    log.debug ( v_log_orgunit_code, v_log_context_code, v_log_module_code,
    v_log_my_name ) ;

    Best regards, Helmut

    • Avatar

      Sorry my examples were reformated – I dry to explain in words. I meant:

      “‘ ROLLBACK performed !’;” should begin under “v_log_routine”

      and v_log_my_name under v_log_orgunit_code

  16. Avatar
    Amin Adatia Reply

    SQLDM 4.1.2-895
    Logical Model
    How do I get the relationship lines not to have corners? I looked in preferences under
    Data Modeler
    => Diagram=> Logical Model
    => Model => Logical
    I cannot find the Auto Layout checkbox

    How to reset everything to factory setting?

    • Avatar
      Amin Adatia

      Ordinarily I can live with 2 or 3 crossed relationship lines. I prefer to have straight lines. So I would like to have the default to be straight lines, which seems to have been the case except in this new place of work, but I can see perhaps a case or two where elbows might work better. If it is an either or situation then I would take straight lines.

      Regards

    • Avatar
      Amin Adatia

      And the straighten line choice is not available when you select the relationship line.

    • thatjeffsmith

      Ctrl/Cmd+A

      Right Click

      Straighten Lines

      The elbow are there b/c someone put them there – you didn’t add them, right? And they’re not there by default.

    • Avatar
      Amin Adatia

      Ctrl + A selects everything; not just the lines
      Right clink on any blank part of the screen bring up the menu with layout. Auto Route is checked! No idea why/how. Un-selecting Auto Route allows the lines to be straightened. After saving the diagram, closing and re-opening, the line is again bent and Auto-Route is checked.

    • thatjeffsmith

      so you toggle ‘OFF’ auto route, then you ‘straighten lines’, you SAVE the design, close, re-open and the auto route property is still active?

    • Avatar
      Amin Adatia

      Toggle + Save + Close + Restart solves the issue
      Thanks

  17. Avatar

    Hi Jeff,

    In package body edit mode I usually navigate a lot with ctrl+click. Let’s say I go from proc1 to proc2 by clicking on the call to proc2. Then go to proc4 from proc2 and to proc3 from proc4. Now I would like to go back in the opposite order (proc3->proc4->proc2->proc1). Is there a keyboard combination for that or any other way to achieve this, i.e. go to the last location I jumped from by ctrl+click and then one before that and so on? Would save me lots of time.

    Best regards!

  18. Avatar

    Is there a way to get SqlDeveloper working in el Captain (MAC) without disabling System Integrity Protection? The instant client DYLD library is getting Quarantined, so the connections are failing. Disabling the SIP fixes the issue. I was hoping to avoid this method.

    • thatjeffsmith

      sure, just go straight JDBC, in other words – don’t use the thick client to connect

      In my humble opinion, Apple went a little crazy here. But that’s just my personal opinion. I know we have folks here looking at an official recommendation.

  19. Avatar

    Please help me from pulling out the remnants of my hair… I’m using v4.0.3.16 and, when I click on a table in the Tables folder of the Connections window, it opens the table in the editor as I have seen everywhere else I have used SQL Dev. But the particular install I am using at the moment doesn’t show the Data tab (normally between Columns and Constraints) in the Editor window. It also doesn’t show up in the floating Desc window.

    Any ideas?

    • thatjeffsmith

      particular oracle database install, or particular sqldev install?

      4.0.3 is a release back – can you try with v4.1.2?

      I remember seeing this behavior in v4.0, but haven’t seen it lately.

      Also, the DATA tab isn’t included in the DESC popup windows. You can float a table editor and use that as a DESC if you want to see the data though while you’re working in the worksheet.

    • Avatar

      Hi Jeff – thanks for the quick reply!

      This particular sqldev install. I have used sqldev in three or four other places and not encountered this before.

      I’m intrigued by what you mean when you say ‘float a table editor’… can you expand on that, please?

    • Avatar

      Ah. I thought it was something else. The Data tab isn’t there either, sadly.

      Just upgraded to 4.1.2 and it’s the same (well, it now has a Model tab, but still no Data tab)

    • Avatar

      I’ve just noticed something that may be related – some of the tables in the schema have a greyed out icon. If I click one of those, the Data tab doesn’t display.

      Close that window, click on a different table with a non-greyed out icon and the Data tab appears. Now, if I click on a greyed out icon table – the data tab is there! Close that window again, click on a greyed out icon table – and no Data tab!

      Weird…

    • Avatar

      Hmmm. I’ve checked Grants and the information on the Details tab of two tables – one greyed out and one not – and they are the same (to all intents and purposes)… can you think of anything else that could be different that I should look for?

    • Avatar

      I’ll try the screenshot first… Note the greying out in the Connections of ARREARS_ACTIONS, but not APPLIANCE_TYPES or AF_GAS_TOTALS, yet the Data tab only appears on AF_GAS_TOTALS.

      And for the SQL – did you want the generated SQL DDL for Create?

    • thatjeffsmith

      you’ll have to upload the screenshot to an online image sharing service, I don’t see anything

      and yes, i want to see the SQL to see if there’s anything ‘weird’ at play

    • Avatar

      (Test post without links – not sure the one with links came through…)

  20. Avatar

    Can You Help me I want repeat number five 10 time in sql using pl/sql , so can you Help me

  21. Avatar

    We have a migration set up in SQL Developer; we run this periodically (a few times a month) to move data from a SQL Server instance to Oracle for reporting. We need to do this more frequently (daily) and want to automate it using sdlcli64. Is there a way to export the migration parameters/settings we use in GUI SQL Developer for use in sdcli64?

    Thank you.

  22. Avatar

    We’ve had to move away from PL/SQL Developer due to budget cuts and I’ve held off putting this here for a number of reasons, maybe it’s a Monday morning thing but here are my top 5 aggravations for SQL Developer. If you could fix this it would make using SQL Developer so much more smoother to code in:

    1. For editor code templates of key words etc. you have to hit ctrl+ space bar (which doesn’t always work) whereas PL/SQL developer has just a space bar which helps more than it sounds. I’m sure the counter argument is well you might not always want ‘ssf’ to transform, well that doesn’t happen very often at all.
    2. In PL/SQL Developer when you alias a table the available columns are displayed pretty much instantly when you type for example “alias.” This makes a big difference.
    3. Bug: if you are running a query and open a new instance the default view settings are displayed on the newly open instance.
    4. I’m sorry but the SQL Developer formatter is no good at all, the formatting looks terrible even when you change the settings to the best possible options, PL/SQL Developer calls it a beautifier. Look at the options they offer and just how good it can look and copy it 🙂
    5. You start typing in SQL Developer and you instantly get the red unlined text before you’ve even run anything, this is very annoying, at least let me do something incorrect before following me with a red underline!

    Thanks!

    • thatjeffsmith

      Thanks Dave, and I appreciate your situation.

      1. They’re not auto-done today, and that’s intentional. It seems for our users when the tool ‘automatically jumps in’, especially in the editor, that’s when there’s the most amount of unrest. So, I hear ya, but this isn’t likely to change today.

      2. Not sure exactly how you mean, can you provide an example? If i alias a table in the FROM, i can reference the columns in the SELECT and WHERE bits using the alias.lookup feature as fast as I can hit ctrl+spacebar?

      3. ‘the default view settings are displayed on the newly opened instance’ – are you saying you’re opening a 2nd copy of SQL Developer? Why do that? If you’re running a long running query, just open an unshared worksheet, and you’re good to go. That gives you a new connection. Or run your long running queries on the unshared worksheet to start with so you don’t tie up your SQLDev tree/worksheet/report connections.

      4. I won’t agree that it’s ‘no good at all’ but I will say that we’re building a new one. So hope springs eternal – you shouldn’t have to wait that long for it either. Stay tuned.

      5. It’s wrong until it’s not…are you saying you want a delay? You can also hide the grammar ticks completely or change the line style/weight/color so it’s less annoying.

    • Avatar

      1. OK

      2. For example I type this “SELECT FROM xx_custom_table xx” then I can use “xx.” To quickly reference any column from the table

      3. This is more to do with our woeful connection in the north of England, every 15 mins the connection fails, but it will still run a query if you started to execute it. As I say if you open a new instance this will appear, no big issue just making you aware it does this!

      4. Yeah agreed that may have been a bit much, but I’ll look out for the update thanks

      5. OK great I’ll configure this thanks, I have been through every menu item and it’s not jumping out at me, could you point out the path please.

      Thanks.

    • thatjeffsmith

      What exactly are you seeing on the alias? It’s working for me…

      3. ‘if you open a new instance this will appear’ – what exactly is ‘this?’ Sorry for being dense 🙂

      5. it’s well hidden 🙂 So I wrote a post for it.

    • Avatar

      Yes that’s exactly what I’m after! I’ve watched your video “Completion Insight in Oracle SQL Developer v4.0.2” and have all the options checked in code editor > completion insight but it simply doesn’t work.

      When I say open a new instance and this will appear I mean… customize your toolbar so remove say ‘new’ and ’undo/redo’ run a query that takes more than a few seconds to run (in our case select * from dual 🙂 ) and while it is running open a new instance and you will see that the customizations that you made will now have gone back to default settings.

      Thanks for the help. Using the ‘SQL Editor Code Templates’, ‘PL/SQL Syntax Colors’, future formatter updates and whatnot I’m back to coding happily.

    • thatjeffsmith

      Hmmm, so I never customize toolbars. And I don’t think we write the settings to file until we close, so opening a new instance will open things as they appear on disk (preferences, settings), so that kinda makes sense.

      Can you give me an example of what you’re trying for insight? Can you give me an object you’ve created DDL and then a sample query you’re trying to write against it with an alias?

    • thatjeffsmith

      does that table have more than 10 columns? because in the preferences you’ve told it not to popup if there’s more than that many hits

      also, your delay is way too fast – it will drive you nuts once you get it ‘working’ – increase the delay

      hit ctrl+spacebar to force the suggestions up regardless of what the filter is set to

  23. Avatar

    Hi Jeff

    Thanks for previous reply on supported Subversion version – seems you are all correct – at least I have been able to access our existing Subversion repository v1.6.11 with both SDDM v4.0 and v4.1 (just had to turn off the Proxy setting in SD).

    Next story – we try to migrate from CA Erwin v82, but can only produce v73.erwin files – the Repository xml files to use for import into SDDM turns out to be v82 (of course). And since we do not have any Erwin 7.3 installation, the follow up questions becomes: will there be any support for Erwin 8.x migration into SDDM or are there any clever workarounds for this issue?

    Thanks again!
    Jo

    • thatjeffsmith

      probably not, sorry

      keeping up with Erwin versions just isn’t worth the effort

      workarounds, you get get the data dictionary itself via a Database import or using a generated DDL script

      I’m guessing if you’re paying support to CA, they would make a v7 download avail to you..you probably just have to ask for it via their support. Most companies work that way.

Write A Comment