Nearly 7,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.
- 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.
- 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.
- 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!
7,563 Comments
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.
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
* “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.
this is the direction you want to go
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?
Google is your friend
I haven’t tested this in SQLDev yet. I know we are fixing some bugs around this space for the next version.
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
Yeah, that’s what I was thinking, but I have no clue what it could be, any ideas?
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”
something is ‘weird’ with that machine
Any idea what it could be?
did we cover you running it as an Administrator yet? windows permissions or application security getting in the way is my last guess
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.
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.
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?
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.
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?
I am trying to find the sql command line client for Mac OS.
Try SQLcl – works great. Only 12MB, tons of features. I talk about it here on my blog, a lot.
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!
nuke your appdata 4.1 system folder and try starting it again
Did that, same thing – it’s still creating the lock file
show me what that looks like…
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).
yeah, what’s it called. what else is in that directory. what happens if you delete it?
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)
thanks, that might help me track down what’s happening
Any ideas?
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
not today, but there’s some fun stuff we’re doing with client side java scripting that should be good to go in the next version, assuming you want to run that code – we’ll provide a sample, but it won’t technically be a vendor provided feature as you’re describing
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
sorry double posted
regards john.
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.
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.
Hi,
Are there hash files for the SQL Developer download file? If so, how do I obtain one?
Thanks.
no
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
it’s easy
write a login.sql script
put all of your scripting preferences in there via SET commands
you’re good to go
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
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
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
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.
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.
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.
winner 🙂
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?
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
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.
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
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.
Ok, can you post a scenario to our OTN Community forum space?
https://community.oracle.com/message/13595200#13595200
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.
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.
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?
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?
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?
ayup
then then you start 4.1.2, it should see the 402 folder and ask if you want to copy the stuff over
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….)
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
you can get your SQLHistory and connections too…
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.
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
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.
you can also tell SQLDev where to store your settings, Kris talks about that here
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
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
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?
you mean you want to remove the ‘elbows’ or the you only want STRAIGHT lines?
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
And the straighten line choice is not available when you select the relationship line.
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.
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.
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?
Toggle + Save + Close + Restart solves the issue
Thanks
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!
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.
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.
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?
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.
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?
right click on the document tab for the table, and say ‘float’
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)
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…
‘some of the tables’ – do they have anything in common?
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?
can you post a screenshot? and send the SQL page for the script for one of them
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?
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
(Test post without links – not sure the one with links came through…)
sorry, don’t see anything
Hmmm
Let’s try with just the screenshot link
http://1drv.ms/1ONX2ZZ
Now a link to the DDL for the three tables (sorry this is so tortuous, Jeff – you really do have the patience of a saint!)
http://bit.ly/1jMqClP
Hi Jeff
Were those items any help?
i couldn’t get access to your DDL files, i get a bad link
Sorry Jeff – it’s been incredibly problematic, and I probably appear a complete noob.
Is this link any better for the SQL
http://1drv.ms/1TB1b2R
Can You Help me I want repeat number five 10 time in sql using pl/sql , so can you Help me
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.
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!
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.
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.
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.
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.
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?
ok i give up! here it is:
http://postimg.org/image/s8u2x4h9f/
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
Fixed, thanks again.
Awesome-O!
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
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.