SQL Developer in VS Code Tutorial (2024)

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
In January 2024, the Oracle team released a new extension for Visual Studio Code for working with SQL: Oracle SQL Developer for VS Code.
In this video, you'll learn how to install this new Oracle SQL Developer extension in VS Code, how to connect to a database, how to run queries, and several of the other features of the extension.
⏱ TIMESTAMPS:
00:00 - What this tool is
00:30 - Install the extension
01:20 - Add a connection
02:30 - Write a query
05:00 - Save the file
07:00 - Object browser
🔗 VIDEO LINKS:
Announcement blog post from Jeff Smith: www.thatjeffsmith.com/archive...
Community Forum: forums.oracle.com/ords/apexds...
Documentation: docs.oracle.com/en/database/o...

[@harshitasharma4865]

The most perfect video i was looking for thanks ❤

[@DatabaseStar]

Glad it helped!

[@stevekirsch8284]

Excellent video by the way. Really great information and concisely conveyed.

[@DatabaseStar]

Glad it was helpful!

[@WaleedJokhan]

How can we use the VS code to version control Oracle database development, using Git repository on DevOps?

[@DatabaseStar]

Good question. VS code has great built in integration to version control such as GitHub. I have some videos on using this but not specifically in VS code.

[@kumotskie]

Great videos! New subscriber here. Thank you. I just want to ask what’s the difference of this extension with the one named oracle developer tools for vs code ( sql and plsql )

[@DatabaseStar]

Thanks for the sub! I'm not sure what the difference is. They are both developed by Oracle. I assume this new extension will replace SQL Developer and maybe they will stop the "Oracle Developer Tools for VS Code" extension. But that's just a guess.

[@user-gn1gy3pw9d]

If I run a create or delete query script. How do I commit the changes to the database or if it automatic how to rollback? I don't see the option. Thanks

[@DatabaseStar]

There may not be a commit button on the editor yet. But you can use the COMMIT statement to commit changes or ROLLBACK to roll the back.

[@harshitasharma4034]

Please help as it shows : A connection with the database could not be established

[@DatabaseStar]

Is the Oracle database running? Have you entered the correct SID or service name?

[@harshitasharma4865]

Not its not running and i entered correct details only

[@cathrerinezetadrones3169]

I'd like to add version control on my packages, how can this be done for oracle through VS Code?

[@DatabaseStar]

Good question. Yes, VS Code includes an integration to GitHub and other version control systems. I'll create a video on this in the future.

[@edhahaz]

Amazing overview thanks. This seems sufficient as a replacement for the crusty sqldeveloper. I just don't know how you created the oracle db.

[@DatabaseStar]

Thanks! Yeah I’m looking forward to the extension being further developed. The Oracle database I had already installed on my computer. I used Oracle Express.

[@soufianamziane1355]

Bro can you pleas tell me how to download and set up the oracle express so that the extension will know it 🙏🙏

[@shankar99977]

Subscribed.. thanks for this.. Is any additional features in this extension which is not available in sql developer app

[@DatabaseStar]

Thanks! Not as far as I know. It's a pretty new extension, but the team at Oracle will be adding more features to it in the future, rather than adding to SQL Developer.

[@30-e-harshitsinghbhadauria85]

i am not able to figure out which username and password have to be given at the time of writing the connection details while extablishing the connection . if anybody can help me pls help i would really appereciate it !!!

[@DatabaseStar]

It really depends on how your database is set up, such as Oracle Standard or Express or whether it’s on your computer or another server. It’s the same as what you would use on SQL Developer.

[@oida10000]

I am using this extension and it works fine, but I can't find an option to export my query results to a file or even copy them in a good manor, does anyone know how?

[@DatabaseStar]

I thought you could select the results and copy them. If not, I'm sure it's something that the team will release soon. According to Twitter, they seem to be making regular enhancements to it.

[@stevekirsch8284]

When I export, it always exports nothing, no matter what format. There appears to be no way to import a CSV file that I could find. Also, if you want to change the types of fields, you can't do that in the GUI like you can in SQL developer. These seem like pretty basic features. I am impressed with what is there so far. I was amazed I could set the NLS parameters like the date formats in the main Settings for VSCode.

[@DatabaseStar]

Thanks for sharing your experience. I assume these features will be added to the extension over time, so it's the same (and then better) as SQL Developer.

[@shutterassault1]

I'm not following opening a SQL file. When I do this it's not in the SQL worksheet type environment where I can run commands. It's just like opening a regular sql file in VS CCode.

[@DatabaseStar]

Yeah, I think that's intentional, it's opening an SQL file from within VS Code.

[@JimCooper-no1zm]

We use APEX in an educational environment where APEX is cloud-based including the database. We do not install Oracle database locally. I would like to use the VS Code extension. Will there be a database that can be accessed using VS Code extension?

[@DatabaseStar]

I think you can still access the database using this extension, assuming you can access it using something like SQL Developer. I’m not sure though as I’ve never used Apex.

[@jargalsarantsetseg8843]

for really beginners create connection is really confusing, where can i find hostname or service name?

[@DatabaseStar]

It depends on where your database is. If it's at work or university, you can get it from your database administrator or maybe a work colleague. If it's on your own computer, you would have specified this when you installed Oracle.

[@74Bharath]

When i try to install the extension, it says “ not compatible with the current version of vs code (1.77.3) can anybody please help me And may i know which version of vs core you are using?

[@DatabaseStar]

I'm using version 1.86.1. Perhaps the 1.77.3 version is too old for the extension. I just Googled and that version was out in Mar 2023, and the extension was released in 2024. Perhaps updating VS Code would work.

[@74Bharath]

@@DatabaseStar thank you doing that now.

[@sameershah860]

Hi! Can I request you to make a video for the MySQL extension by Weijan Chen and how to create a database from scratch on VS Code? I'm really struggling to find out how to make and connect databases on VS Code through this extension. I have not used MySQL workbench and have no databases available as I am extremely short for time on my project. (It's a web-based application in which I use Python MySQL at the back end and html at the front end) It's my first project 🥲👍 Any help would be appreciated 😭

[@DatabaseStar]

Hey, that's a good idea for a video. I can make a video for that! I'm not familiar with this extension. If you need to make your database soon, I would suggest making it in MySQL Workbench and then accessing it in VS Code, as that may be faster than waiting for my video.

[@pujaguchhait6385]

"Error: A connection with the database could not be established" this is what i get. Is there anything i can do to fix this ?

[@DatabaseStar]

Do the same connection details work in other editors such as SQL developer?

[@soufianamziane1355]

Bro the same error showing can you tell how to download and set up the oracle db so that the extension will know it

[@harshitasharma4034]

Hi is your error resolved?

[@bda4029]

Make video on how to find connection name,username,hostname&password etc details..

[@DatabaseStar]

Good idea! This can be tricky sometimes.

[@stevekirsch8284]

I think the single most annoying feature of Oracle SQL developer is the error messages are horrible because they never point out where in the code you made the mistake. It looks like using VS code is a huge step forward in helping you find why your code isn’t working. Do you agree with that?

[@DatabaseStar]

Yeah it's hard to translate the errors and understand where your code may be broken. I agree, it seems VS Code is much better at doing this. The application itself is used by a lot of other developers (outside of SQL development), so it's good that Oracle is now using it.

[@medilies]

So this is exclusive to Oracle DB...

[@DatabaseStar]

Yeah that’s right. This extension is made by Oracle for Oracle database. But there’s another extension that works for SQL Server, MySQL and Postgres which I have a video for on my channel.