Oracle SQL Developer Tutorial (Feature Demonstration)

Oracle SQL Developer is a free IDE made available by Oracle. It's full of handy features and has only gotten better over the years. It runs on Windows, MacOS, and Linux.

This Oracle SQL Developer tutorial will walk you through the most useful and common features of the tool.

In this tutorial video, I'll show you a range of main features of SQL Developer. Here are the timestamp locations for the features:
00:00 - Start of video
00:45 - Main window
01:19 - Create a connection to a database
03:29 - New worksheet
03:57 - New SQL file
04:45 - Simple SQL query, inc Run Query and Run Script
06:27 - Pin query results
06:45 - Explain plan
07:19 - Commit and Rollback
07:39 - Format SQL
08:03 - Preferences

[rikusjooste]

You just summarized a 1.5 hour lecture to less that 10 minutes. Thanks!

[victoriamalone]

This is the thing I needed! Thank you!

[joannapedretti]

can you please link the videos that go more in depth about the connections? i’m not even sure what a connection is, like am i supposed to have a database made already and then connect it to this app?

[keegans]

i have this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
what can i do? :(

[AtlantaKid]

I am using Oracle Linux on a Dell 3410 laptop with Oracle 19c installed the menu fonts for the SQL developer on the left panel and menu in general are too small, is there a way to change those? I have changed the editor's font, which works, the other thing I can do is to change my laptop screen resolution size or its zooming, which will take away from my working space.
Thank you for these great tips.

[jest]

I have a table but there are some columns that I don't plan on using. Normally when I'd use a table I'd just select the entire table but what do I do in this case? for example, I don't want to use the first and last columns and I just want to select everything in the middle, how do I do that?

[raghadm]

I have a problem with the password, I downloaded the program and I encountered a problem with the username and password, and I did not put these things previously, I just downloaded the program

[kyriakosmargaris]

Where is the link that you have linked in the description? (you said that at 2:52)

[qpxqlyr]

You skipped the password part at 2:02 What is the password for it ?
and i am getting this error even after giving all data from your video ....
error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

[m.lmanyela]

Link to a page to resolve common database questions?

[roshanrajkumar]

I want to run DBSAT tool, how can I do that using sql developer?

[ibrahimbah]

where is the page to resolve the problems