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.
- 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!
Comments 4,099
Not a question, but a comment. I had SQL*Developer in Windows 7 open with a lot of unsaved work. The UI stopped responding. I could move and resize the window. I could drag other windows across it. Each time, SQL*Developer updated its window without a flaw. However, I couldn’t click anything. Unresponsive. I right-clicked on the title bar and selected “close”. I was amazed to see SQL*Developer ask me if I wanted to save each item of unsaved work. Wow! When I reopened SQL*Developer, everything opened with no issues. Nice job!
Hi Jeff,
I was trying to send some data from inside my form to Excel and I tried what you said in the community forum:
SET SQLFORMAT CSV
SPOOL c:\users\user\data.csv
SELECT * FROM EMPLOYEES;
SPOOL OFF
Problem is the command Set sqlformat csv gave me an error. I tried it in SQLPLus to see if it works there and it didn’t either. Would you please help me with this? Thank you.
Author
csv lowercase…
It is only available in SQLDev and SQLcl
Oh OK, thank you very much.
v18.1.0
How do I get from Sessions SQL_ID to details of the Real Time SQL Monitor?
The SQL_ID from Session does not show in the Real Time Window
By the way, is there any way to increase the Font Size in the various dialog boxes? I am using the Oracle Look and Feel. Tried Windows and that is just ugly
Author
I’m on vacation and away from my PC..is it not listed in the grid on the page of available reports?
Hi Jeff,
In the leftmost pane you can place a filter on a schema’s tables by right clicking on “Tables”.
But in the filter expression, how do you protect wildcards?
e.g., I want to search for the literal ‘_RR_’. How do I protect ‘_’ from being interpreted as a wild card?
Author
AFAIK, you can’t. I’ve tried and failed. I’m out on vacation for a week, so you might get a better answer if you post to our official forums.
Workaround is to use the Schema Browser and the client-side filter, that should work just fine.
If you open the View > Log > Statements panel, you’ll see how we’re constructing the SQL to filter the tree objects.
v18.1.0
I am trying to find dependencies on a particular package A
On the Package Body — the dependency tab shows Package B
The Find Database Objects does not show anything to do with Package B
How do I find the dependency of A on B
Code in A uses Views which call Functions in B — but should this not show someplace in Find Objects?
Author
I think this feature might be borked, consulting with DEV to make sure we’re not both doing something ‘wrong.’
Hi Jeff,
When using SQL Developer 18c, I am performing a “create like” on a user. Everything seems to work perfectly with the exception that the “profile” of the user being copied is not put in the “create like” sql. Is there some type of environment setting that I don’t have enabled?
Thanks,
Dave
I noticed very strange behavior
When I change the ojdbc8.jar stored in the jdbc\lib folder, it does not pickup the modified or patched version, unless I edit the sqldeveloper.conf file. This makes me thinking is that it is somewhere caching this file and does not lookup the newer version
SQL Developer version : 17.4.0
OS : Windows 10 1607
Java 8
Is there a way to clear the cache or force SQL Developer to use updated jar files. I could not find any documentation.
ojdbc8.jar has various bugs and I download the patches from Oracle and manually patch the ojdbc8.jar file. I want to make sure that SQL Developer picks up the new file.
I use the below batch file to start my SQL Developer
@echo off
set IDE_USER_DIR=”C:\abc\%USERNAME%”
start /d C:\abc\local\sqldeveloper\sqldeveloper\bin\ C:\abc\local\sqldeveloper\sqldeveloper.exe
Author
>>When I change the ojdbc8.jar stored in the jdbc\lib folder,
You’re not supposed to do that. It’s unsupported.
In that case SQL Developer will fail to connect to Oracle 11.2.0.4 database that uses the oid entry with TRANSPORT_CONNECT_TIMEOUT=3. As in 12c Oracle supports millisecond for this parameter, there is a known bug in the delivered ojdbc8.jar which reads this parameter as millisecond and fails to connect and gives the error :
An error was encountered performing the requested operation:
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of server requested in connect descriptor
Oracle support has provided a patch
Patch 25977056: AC: UNITS FOR TRANSPORT_CONNECT_TIMEOUT CHANGED WITH NO QUALIFIER
To fix this issue and below document specifies how to patch the standalone ojdbc8.jar
How to Manually Apply a One-Off Patch to the JDBC Thin Driver or to the Universal Connection Pool When Oracle Client or Database Home Is Not Available To Apply the Patch via OPatch (Doc ID 431463.1)
My Question is if we are not suppose to update the ojdbc8.jar (I thought we can use SQL Developer with appropriate user provided jdbc driver), How are we going to get fix for SQL Developer fails to connect to Database that uses oid entry with TRANSPORT_CONNECT_TIMEOUT=3 parameter.
Please respond. I can open a support case with Oracle if needed for SQL Developer. I am surprised that we are not allowed to update the ojdbc8.jar with the oracle provided patches for a oracle supported product. Please clarify as jdbc patches are posted all the time.
Author
Those jar’s are provided for folks and their java applications.
But SQL Developer is different. It’s our app, if you change it, you’re on your own, and you’re no longer supported.
If you want us to pick up a new jar, you need to open a SR.
We generally pick up the latest drivers/jars as each release comes about. It’s possible that’s already in there for 18.1 – available now on OTN. I’ll check with the devs and if not, will see about getting it included for 18.2.
Thanks for the update. I understand it is not supported to update the ojdbc8.jar. However sometimes the delivered ojdbc8.jar breaks and Oracle support has fixes that we can manually apply. If you can explain how the caching of jar files work, it will be easier for us to use it till we get the official fix in newer versions.
As I have said earlier, only workaround I found is to update the sqldeveloper.conf file and restarting the SQL Developer and it picks up the updated jar file. However not sure if this is the best way.
I fully understand that using in this manner, it will be out of support from Oracle.
I will test 18.1 and see if the fix is there or not. If not will wait for 18.2
Author
that patch fix was delivered for the 12.2.0.2 driver, which hasn’t officially been released yet. We’re running 12.2.0.1. When that comes out, or if it comes out as an 18 jar, we’ll pick it up.
What you’re doing isn’t supported by us, but it would work.
Hi Jeff,
Could you please explain the difference between code generated when using:
1. Synchronize with Data Dictionary
2. DDL File Editor ?
I understand that the first approach creates diff statements, but if we are creating new table shouldn’t these two generate the same output?
Automatic indices and Table DDL transformation are missing although they have been set up.
Author
Probably. I think when you’re generating DDL there’s a place to enable the DDL transformations, so be sure you’ve done that.
Another quick question regarding custum transformations.
I know that it is possible to apply the transformation to the whole relational model by right clicking on the model, but is it possible to apply the transformation in similar manner to a subview or an object?
Author
I don’t believe so…not without coding that into the transformation bits itself.
You might get a better answer if you ask on the Data Modeler forums though.
Thank you!
When using SQL Developer to do a Database Export, a snippet of the resulting DDL is:
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
)
NOPARALLELCREATE TABLE MRDP01_OWNER.ADDRESS_R
(
ADDRESS_ID NUMBER(6, 0) NOT NULL
, REV_DT DATE DEFAULT SYSDATE NOT NULL
, REV_BY VARCHAR2(8 BYTE) NOT NULL
, ADDR_LINE1 VARCHAR2(100 BYTE) NOT NULL
“NOPARALLELCREATE TABLE” is not right, it should be “NOPARALLEL CREATE TABLE” and fails when I try to import the exported ddl.
What am I doing wrong?
Thanks,
Dan
Author
Looks like we’re doing something wrong, not you. Can you share the ddl for the 2 tables so I can try reproduce locally? Also, what version of SQL Developer are you using?
Jeff,
Thanks for your quick reply. I am using SQL Developer 18.1.0.095.
The DDL for 3 tables which have the bad syntax is 266 lines long. Might not be so good to paste here. Can I get it to you another way?
Thanks,
Dan
Author
[email protected]
Hi jeff,
Greetings of the day!
I want genarate excel files(.xlsx) from sql developer ,Here is the scenario.
I had 10 sql queries .each produce one table.I want to put each qurey result in one work sheet and all work sheet’s in one excel file .
Above 10 sql queries run multiple times and produce excel file same as above mentioned .
Example: query1 –>worksheet1
query2 –>worksheet2
………………………………………….
………………………………………….
query10 –>worksheet10
________________
excel file1
like this way i want produce more excel files
Author
We can generate 10 spreadsheets for 10 queries. Or, you can create a VIEW for each query, and we can export the 10 VIEWs (which would be your query), to separate sheets in one Excel file.
Hi Jeff,
I’m able to use SQL Developer 4.1.5 (yes, we’re trying to get to 18.1 soon) to schedule a nightly RMAN backup in DBMS_SCHEDULER on a 12c database very quickly and easily. Is there a way to do the same thing on an 11g database using SQL Developer? Thanks,
Mark
Author
How are you doing it for 12c? Did you try and fail for 11g?
I created a “Script” job type with a “Backup” script type with a “connect target /” followed immediately by an RMAN run block in each of my 12c databases. It runs like a champ every night straight out of DBMS_SCHEDULER. However, the Script job type doesn’t exist in 11g so, I’ve tried numerous times to create an “Executable” job type and associate a valid credential with it. But I always run into “ORA-27369: job of type EXECUTABLE failed with exit code: Operation not permitted”.
My executable (bash shell script on Linux with permissions wide open) exports the ORACLE_SID and ORACLE_HOME and then does:
$ORACLE_HOME/bin/rman target / nocatalog << EOF
run {
backup database;
}
exit;
EOF
Is there a better way to do this against an 11g database? Thanks,
Mark
Author
See the docs and Example 29-5 Creating a Detached Job That Performs a Cold Backup
Yep, tried that very thing yesterday numerous times and it always looks like it’s going to work. However, the job goes into “RUNNING” status but never actually does anything, throws an error, or finishes.
Author
I know just enough to be dangerous with rman an data pump – i suggest you share your code with the AskTom folks or post a note to the plsql or scheduler forums.
Sounds right. I was just wondering if you or any of your readers knew of any way to setup an 11g backup job through SQL Developer somewhat like a 12c db. It’s extremely slick on a 12c db using an RMAN Script in SQL Developer. So much so that we’ve moved all of our 12c nightly backups to DBMS_SCHEDULER jobs using SQL Developer. However, our 11g backups remain defined as OEMCC jobs until we can find a better method like SQL Developer has for 12c. Thanks,
Mark
Hi Jeff –
Using sqlcl distributed with 12.2 (SQLcl : Release 12.2.0.1.0 RC). Linux x86.
If I run sqlcl as the oracle user, root user, other users, everything seems to be fine.
For some reason, my personal user, as soon as I touch any key after connecting and sitting at the SQL> prompt, I get:
SEVERE: null
java.lang.NullPointerException
at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.readLine(DbtoolsConsoleReader.java:2725)
at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.readLine(DbtoolsConsoleReader.java:2590)
at oracle .dbtools.raptor.scriptrunner.cmdLine.SqlCli.startSQLPlus(SqlCli.java:861)
at oracle .dbtools.raptor.scriptrunner.cmdLine.SqlCli.main(SqlCli.java:399)
I can connect to the databases just fine, I get to the SQL> prompt, and get the exception as soon as I press any key.
I’m using bash and have stripped my environment down to nothing but the oracle variables and JAVA_HOME, identical to other users that work, but can’t seem to fix or find the issue.
Thanks.
v18.1.0
When looking at a table data or Sessions (Monitor Sessions)
Is there anyway to set the Font of the headers. Currently the Line Number starts getting the …. when I reach to a 10000
Author
I can’t reproduce this for any report, the line numbers show ok for me, even to say 11,250…can you send me a screenshot? Post it to say imgur and send the link here as a comment.
The font for the headers in v17.4 is fixed Courier size 10 while in 18.1 it seems to be Arial size 14 or 16
Author
row # isn’t a column header though, so not sure what you’re seeing.
Removed the old installation and re-installed and this time did not opy setting from v17.4. Seems to have solved the problem
Is it possible in SQL Developer to run a query against an Oracle database connection and a Teradata database connection at the same time? From what I can tell you can only run a query against one database connection.
Author
You can run 2 queries, one on an Oracle connection and one on a Teradata connection, simultaneously, yes.
But you can’t run a single query that hits both Oracle and Teradata.
Jeff,
Just installed SQL Developer 18.1.0.095.
In the Worksheet tab if I enter the command:
set sqlformat
and execute the result in the Script Output is:
SQL Format Cleared
In the Worksheet tab if i enter the command:
set sqlformat csv
execute the command (nothing in the Script Output) and then execute a SQL query results are not in CSV format. Works in sqlcl. Isn’t it supposed to work in SQL Developer?
Sorry, I was executing command, not script.
Author
Absolutely that should work. Try an app restart?
Hello,
I just upgraded to 18.1 and find that the auto-format to UPPER Case for Keywords is no longer working. Is this a bug that might be fixed, or is there a setting beyond Tools –> Preferences –> Code Editor –> Format: Keywords Case: UPPER ?
Thank you for your feedback!
Author
It was removed as the formatter already covers this use case. You’ll just use it on demand via Ctrl+F7. Make sure you set the case preferences appropriately first, of course.
Hi Jeff,
Is there a setting to make the highlighted occurrences stay highlighted even though one clicks with the mouse in the SQL editing window? Or even if one starts typing? I am asking this because sometimes it is extremely useful to have a term highlighted while coding.
Thank you in advance and congratulations for a great product!
Peter
— Athens, Greece
Author
Thanks Peter!
Not super obvious, but once you have your code highlighted, hit the tab button to get your cursor back to the editor, then you can type. Your highlights will remain. If you mouse-click, they’ll go away though.
No, thank you! I would not have found this in a million years. Hope you fix this soon though!
Thanks again for the work-arround!
Peter
— Athens, Greece
Hi, Jeff.
Is there a way in sql developer that will automatically convert to UPPERCASE the data during import of CSV files?
Author
No…but several thoughts:
v18.1.0
I run a script which calls other scripts and the output goes to a spool file. The script stops running part of the way.
In 17.4 the prior, the script completes and I also get a complete spool file.
Author
W/o your script, there’s not much I can do. Can you build a simple test scenario that demonstrates the issue?
In the Logs I see a line
Source => o.d.r.newscriptrunner.ScriptRunnerContext
Message => Could not write
Hi Jeff
We are using ORDS 17.4 [without APEX , without PLSQL Gateway].
is ther any way to get requested URL (or my template path or my template ID) and remote IP from my GET handler (source type : query or collection) ?
regrading to owa_util.get_cgi_env it is working only source type ‘plsql’.
Thanks
Hi,
I’m probably overlooking something obvious to do with formatting SQL. I can get SQL Developer to format it nicely using Ctrl-F7, but is there a way to format it as a single line, e.g. going from
SELECT
wm_concat(column_name)
FROM
all_tab_columns
WHERE
table_name = ‘&TABLENAME’
GROUP BY
table_name;
to
SELECT wm_concat(column_name) FROM all_tab_columns WHERE table_name = ‘&TABLENAME’ GROUP BY table_name;
I currently do it by copying it into Notepad 2 and using its Align Lines command, but was wondering if there was something in SQL Developer.
Thanks
David
Author
That looks like the opposite of formatting…you just need a macro to remove linebreaks, right?
Yes, but that would be too easy.
Thanks for the tip and prompt reply
What are the benefits of using Oracle Instant Client with SQL*Developer? The SQL Developer 17.4 User Guide references the ‘User Oracle Client’ to configure SQL*Developer to use it, but not why one would want to.
Author
If you need something not available, or easily available via the JDBC driver.
What is the most recent version of Sql Developer? I have 4.0.3.16, and I see references to 4.2 as of Sept 2017. But what is this new numbering system 17.4, 18.1? Has the numbering system changed, or this is a different ‘flavour’ of Sql Developer?
Author
17.4 and soon to be released 18.1.
Yes, we changed the numbering system.
Hi Jeff,
I gather that there’s been a delay of some sort on 18.1. Will it possibly be out this week? Thanks,
Mark
Author
Stay tuned.
Can we change the definition of a word in SQL Dev, so that Control+right arrow skips over underscores? It’s really a pain to stop at each underscore and makes navigation slower.
Author
Preferences, Code Editor. Un-check ‘use change of case as word boundary.’
Awesome sauce.
Hi Jeff,
A SDDM question (v174):
Are there restrictions when importing a ddl file for updating comments (on RDBMS) on view columns from a ddl file into sddm?
Got a ddl file with two “comment on” statements – one for the view and one for a view column. Only the view comment is updated in the model. This is not expected – bug?
Importing a complete ddl file with the “create view” statement into a new model will also set the comment on the view column. So this works fine.
Thanks
Jo
Author
Yeah, that sounds like a bug.
Hi Jeff,
I would like to export all DDL (Tables, Packages,Triggers etc) using SQL Developer (17.4.1) from Tools > Database Export menu.
I would like to export all DDL from a few schema (not my schema)
Is there the way that SQL Developer NOT also export my schema objects.
Thanks,
Binh Le – Greensboro NC
Author
It by default will pick all objects of the said type you have checked on the wizard for the logon schema.
Easiest thing to do would be to logon as one of those 2 schemas vs using a 3rd schema.
If that’s not possible, make sure to pick at least one object of each type in schema 1 or 2 on the object picker.
If you don’t pick any views, but you have VIEWS enabled, it will export every view from the logon schema.
Jeff,
Was trying to navigate the Connections tree via keyboard per your ‘SQL Developer Trick: DropDown Vs Tree (Feb.27, 2012) and ran into an issue. The version of SQL Developer is 17.3.1.279 (Build 279.0537).
Cursor was on the database instance and pressed ‘O’. Cursor move to ‘Operators’ (yes, some of these could be hidden, but aren’t). Pressed ‘O’ again expecting the cursor to move to ‘OLAP Options’. Didn’t move anyplace. Pressed the ‘Right Arrow’ to expand ‘Operator’. Since there was nothing under it just the little ‘+’ sign disappeared. Pressed ‘O’ again and cursor moved to ‘OLAP Option’. Press ‘O’ again and cursor moved to ‘Other Users’. So why was the ‘Right Arrow’ required prior to the ‘O’ to go from ‘Operators’ to ‘OLAP Option’?
Jeff,
Were you able to determine if this is an error? I believe it should have gone from ‘Operators’ to ‘OLAP Options’ without requiring the ‘Right Arrow’ in between.
Hi Jeff,
Is there any way to import old SQL Developer settings into a new instance after the installation has been completed?
I installed a new version of SQL Developer over my old (‘saved’ in the trash) and during the installation process was asked by the installer if I would like to import my settings. Unfortunately other issues I was having with my desktop forced me to cancel that installation (strange problem unrelated problem with Windows updates where UI didn’t recognize my clicks). I deleted the installation and tried again after rebooting, hoping to see the import settings option again but was disappointed when I didn’t.
Justin
Author
They’re all still there, you just have to copy them over.
Hello,
Is it possible to open from SQL Developer (Files view) a Windows Explorer directly on that folder? Like we have in IntelliJ menu Show in Explorer?
Thank you,
Author
I don’t think so.
Hi,
Is it expected for SQLD 17.4.1 to run the “IndexPreferencesTask” in the lower right corner on every startup?
Thanks, Tim…
Author
Yes.
HI
I’ve been using SQL dev. for many years but still i havn’t find out in what way the “connection selector” dropdown list in the upper right corner of the SQL Work is sorted, is it sorted at all?
Thanks
Gunnar
Author
Open/Active connections first, then the rest alphabetically
Jepp so it does Now when you say so ;-))
Thanks!
We have a huge database with data of different categories of people and many procedures that manipulate the data. We need to provide an api for a mobile application- and other applications in the future- to retrieve data and execute procedures. We need to be able to validate that the request is allowed to be executed on the data it’s manipulating. We have our SSO system on which we’re going to rely for authentication.
Author
>> We need to be able to validate that the request is allowed to be executed on the data it’s manipulating
The right place to do that would be in your PL/SQL code. Either in the POST handler code, or in the stored procedure it ultimately executes.
We thought it might be easier and more performant if it was to be called by ORDS automatically before each request.
One more question, what is the best way to return the response if the request passes the validation with minimal code?
No we’re not. Do we need to use it? and what implications it will have?
Author
security.requestValidationFunction is there to make sure the RIGHT people are allowed to use the pl/sql gateway to execute stored procedures.
What are you trying to do with ORDS? Can you not just secure the resource? ORDS would then require authorization to be in place for every call to it.
Hi Jeff,
We’re using ORDS 17.4 without APEX. We need to do some validations for every request. How can we do that.
security.requestValidationFunction doesn’t seem to work. If it not available without APEX, are there any alternatives?
Your help would be much appreciated.
Author
Are you using the PL/SQL Gateway?
Jeff,
I’ve never used Toad. But a couple users who have used Toad, but have lost that access, claim that they could create a ‘multi-database connection’ in Toad and write a query that selected data from multiple instances. Can SQL Developer do the same thing?
Author
From one of the toads, Toad for Data Analysis or some thing, whatever they’re calling it now…
To do this in SQL Developer, one would use DB_LINKs.
We don’t offer client-side joining of data across jdbc connections.
Do you have any suggested processes, strategies or best practices for management of custom domains and types in SQL Developer Data Modeler that will be shared between several modelers?
Author
Heli suggests keeping them in Source Control as well as your designs themselves.
She’s written an entire book on how best to use the Modeler, feel free to drop her a comment on further elaboration.
Hi Jeff,
I know SQL Developer 17.4.1 released on 3/7. Will there still be an 18.1 released later this month? Thanks,
Mark
Author
yes
Thanks Jeff, but are there still issues with ‘Check for Updates’?
I’m on 17.3.1.279, I see that 17.4.1.054.0712 was released on 7/3/18, and yet when I do a check for updates it doesn’t show me any available updates?
I’m just checking the ‘Oracle SQL Developer’ Center at ‘http://apex.oracle.com/pls/apex/dbtools/usage/cfu’ that it is defaulted to.
I’ve tried with and without proxy, as std user and admin.
As an admin, it started up and told me there were updates, but now that icon (bottom right hand corner of screen) has gone away, and ‘check for updates’ is not returning anything.
Right, I’ve just found another post where you say the check for updates is for extensions, not the product – may be worth adding ‘for extensions’ to the menu option as it’s obviously confusing a few people?
Hi, Jeff,
This version 17.4.0.3555 has a bug.
When you right-click on an external table “edit”, the pop-up shows incorrect “table type”, it shows “normal”, all previous versions show “External”, the problem is: user cannot edit, because “external table properties” is not available.
Please take a look.
Thanks,
Dave
17.4.1.054 has the same issue.
Author
I’ll take a look – but just a reminder for everyone – bug reports should go to My Oracle Support.
I filed a bug in January, fixed in 18.1
Bug 27344008 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=27344008 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=27344008 – SQL DEVELOPER 17.4 LATEST RELEASE NOT ALLOWING TO EDIT EXTERNAL TABLE IN GUI
When are we getting a book names “How to Jeff Smith with Oracle”
Author
Mom, I already told you, no more comments on the blog!
And thanks, I think?
I’d like to share my snippets with a co-worker. Is it possible to export/import snippets?
Author
No, but you can find the xml file they’re stored in and send it to them.
Hi Jeff,
Thank You for all your blogs they are really helpful. I have small question I would like to know how to check if my database is properly normalized currently at present we have lot of performance issues. I think it is because of poor database design how to verify the database design if it is tunned for optimal performance.
Author
There’s no ‘is my model, right?’ test you can have the tool apply to your database. But there are rules, or best practices. But you need to look at if your db is OLTP, a DW, or mixed-use. Also, why do you think the perf is bad b/c of the design? If you have evidence showing that, the lack of a foreign key or a denormalized table would be easy to spot.
http://www.schemacrawler.com/lint.html
https://www.openhub.net/p/dblint
Thought you’d like this slightly amusing bug. Downloaded the latest sqlcl, as you can see. But…
C:\sqlcl\bin>sql
SQLcl: Release 17.4.0 Production on Thu Mar 08 09:15:34 2018
Copyright (c) 1982, 2018, Oracle. All rights reserved.
New version: 4.1.0 available to download
Username? (”?)
Author
Hmmm, I’m not seeing that, but check for the note. I’ll keep my eye out.
I’ve created a logical model & engineered it to a relational model (using standalone Oracle Datamodeler, not as part of Sqldeveloper; version is 4.0.3.853). My destination db is Postgresql. How do I set up Datamodeler to generate Postgres-syntax scripts?
Author
You don’t. Best you can hope for is generic ANSI SQL standard DDL.
How to enable TNS encryption and data Integrity in SQL-Developer connection. I did the required changes in sqlnet.ora on client and server but the sessions to database using SQL-Developer are not showing as encrypted one while SQL* Plus and TOAD one are shown in v$session_connect_info. Are there any special settings required?
Author
SQL Dev is not using sqlnet.ora – we’re jdbc. So you can setup SSL for JDBC or you can tell SQL Developer to use a THICK connection to go via OCI, which will then pick up your sqlnet.ora settings.
Thanks it works using THICK connection to go via OCI. Do you have steps to setup SSL for JDBC?
Hi Jeff, does SQL Developer needs user admin rights to function properly under windows 10?
At some point in time program started reporting “…Could not load connection type:Oracle null ”
(connection preferences, export sql etc…).
This was 4.1.3 but tested with 17.2 and 17.4. versions with same results
All above versions work when running as user with admin rights.
thanks
Author
You just need read/write access to the AppData folders for your Win OS user.
thanks for answering, the problem was solved by not importing the settings from the previous installation (running as admin was working because importing was not done as well, it looks like admin privs had nothing to do with the problem but something with the application user settings…
it works now 🙂
thank you again
Author
Excellent.
Hi Jeff, I am still having the issue in my sql developer showing error while launching “http://apex.oracle.com/pls/apex/dbtools/usage/cfu”.
Since I have configured it for PosgreSql as well some how I am able to run queries but when I wanted to export output the Export Wizard is failing with error “java.lang.NullPointerException”
Would you please help me here to get this corrected.
Author
Can you export from an Oracle database?
Here is my insert querry:
insert into nametable
(id, last_name, first_name)
values
(12345, ‘LeBlanc’, ‘Sarah’);
select * from nametable where id = 12345;
Here is the return:
12345, Leblanc, Sarah
What should I do so that the field displays what I inserted. I want to see
12345, LeBlanc, Sarah
Advice, please. Thanks.
Xiaoling
Author
I’m confused, you’re showing the same values for both the actual and desired results.
I expect to see ” LeBlanc”, not ” Leblanc”.
Author
Show me. Based on normal circumstances, that’s not possible.
Here are the last name from a source table:
LeBlanc
McFarland
de Kok
After inserting query, the last name from the designation table become:
Leblanc
Mcfarland
De Kok
I wish I could paste my picture here, but this form does accept my pictures. I think it must have something to do with the designation table (setting? trigger? etc. )
What do you think?
Author
Something is getting in the way of the data going into the table. A Trigger would be one thought – does your table have any triggers?
There are several triggers attached to the designation table, but nothing looks like formatting name (such as first letter has to be an upper case and the rest lower case).
For instance, the following trigger is the only trigger which has “last_name” involved.
create or replace TRIGGER “SATURN”.”ST_SPRIDEN_NAME_COMPRESS”
BEFORE INSERT OR UPDATE OF SPRIDEN_LAST_NAME, SPRIDEN_FIRST_NAME, SPRIDEN_MI
ON SPRIDEN
FOR EACH ROW
BEGIN
:new.spriden_search_last_name :=
gukcmpr.f_compress_name(:new.spriden_last_name);
:new.spriden_search_first_name :=
gukcmpr.f_compress_name(:new.spriden_first_name);
:new.spriden_search_mi :=
gukcmpr.f_compress_name(:new.spriden_mi);
:new.spriden_soundex_last_name := soundex(:new.spriden_last_name);
:new.spriden_soundex_first_name := soundex(:new.spriden_first_name);
END;
Do you see anything I missed here?
Thanks.
Author
gukcmpr.f_compress_name() -> that looks like a function call. Go see/test what it’s doing.
Thank you, Jeff, very much for your advice and time. I will find out what that function does.
Bye.
Hi,
We have downloaded the following versions of SQLDeveloper and SQLcl
– sqldeveloper-17.4.0.355.2349-x64.zip
– sqlcl-17.4.0.354.2224-no-jre.zip
We have a secured environment and need to supply a PGP Signature or SHA-1 hash or MD5 hash for any files to be imported into the environment. Do you know where I can find one of these signatures for the above files?
Author
md5 hash for your sqldev install is (856c70371862f2f404aff1aed2400cbd) – this is on the downloads page