All of Your SQL Developer Google Questions

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

What are people Googling out there, when it comes to SQL Developer?

Well, Google predictive text makes that kinda easy to find out.

At least no one is asking what it is 🙂

I’m going to address these questions, but we need to address the biggest problem – without context of the actual question, I have to assume or guess what the ACTUAL question is. But, I will go for the most likely scenarios. If I got it close, but missed, feel free to dig in with your comments.

JCE Docs

Java Cryptography Extension (JCE) Unlimited Strength. So, this used to be a separate download. You got a couple of extra JARs that you could add to your Java Home, and then you could work with more secure wallets for authentication. This was recently surfaced in SQL Developer most obviously with our Exadata Express Cloud Service – it required these jars for you to connect.

Good news – with Java 8 update 161 – these JARs are now included automatically. However, if you’re on an older version of Java, you can follow these instructions.

MongoDB

Remember, SQL Developer is NOT a database IDE for any database out there – it’s just for Oracle Database. However, we do allow you to throw in JDBC drivers for supported Migration Targets. That is, we’ll let you connect to SQL Server, so you can migrate that database over to Oracle. So, the question is, do we support MongoDB?

No. But, if you want help migrating from that to Oracle, please let me know. We continue to investigate and add other platforms as our customers require.

Download

This is an easy one. Just bookmark https://www.oracle.com/sqldeveloper. Click on the Downloads button. That will get you to the current version. If you need an older version, scroll down the page.

Download, extract/unzip, and run the sqldeveloper.exe in the parent directory (Windows Users).

Tutorial

Well, you’re already on this blog. Try my resources page – it’s the big link up top that says ‘SQL Developer.’ You’ve also got the Oracle Learning Library, our Hands On Labs, and YouTube.

Change Password

You’ve got a couple of ways you can change your password in SQL Developer. The easiest, if you have a recent version, is you can just right-click on your connection in SQL Developer, and say ‘Reset Password.’

reset password oracle sql developer

If it works, the dialog will just close on OK – if it doesn’t, you’ll see an error message.

This should work whether you are already connected or not.

If you have an older version of SQL Developer, we required that that you be connected already to change your password…unless you setup a THICK connection. I talk about that here – but please, skip this, and just go get the latest version of SQL Developer. Trust me, it’ll be easier.

You can also just type and run ‘password’ in a worksheet. Or you can open the View > DBA panel, go to security, users, and right-click, change password. Or you could always just use SQL in a worksheet and run the appropriate ALTER USER statement.

Certification

We (Oracle) do not offer a Certification program for Oracle SQL Developer. If you want to stand out, the Oracle Certified Master program is the way to go – but you’re going to learn Oracle Database, not how to use SQL Developer.

Filter

You can filter LOTS of things in SQL Developer.

I’m guessing most people are wanting to filter table data or query results though.

Change this, and we’ll re-query the table.

Data Modeler

So, there’s a separate product, Oracle SQL Developer Data Modeler. And, you can run that inside of SQL Developer itself. Both offer the same features and functionality – a complete, end-to-end, design and modeling tool that caters to Oracle Database. A good place to start is with my Resource page. That’s the big link up that says ‘DATA MODELING.’

Our favorite HR model

Export to Excel

Excel, it’s evil. But yeah, we can do that. Import from Excel to Oracle, too even.

a couple of clicks, and your data is no longer safe in the Database…

Data Format

People either ask two things when they start with Oracle:

  1. Why do my DATES include ’12:00:01′ or some other time.
  2. Why can’t I see my TIME with my DATEs?

This is controlled by your NLS_DATE_FORMAT preference, or it’s controlled by your actual query.

If you don’t specify date formats, then the default is defined by your NLS parameters.

Or like I said, don’t rely on a parameter, let your QUERY define how the results will be displayed.

Lots of formats to choose from.

Related Posts

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *