Use VSCode with Oracle Database

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
VSCode is a popular editor for software development. If you work with an Oracle database, you’ll likely be using another IDE as well, such as Oracle SQL Developer.
However, if you use VSCode, you can access the Oracle database directly from within VSCode. You can do this by using an extension.
This means you can run queries and see your data all within the same application, saving time from using different applications. You may also find it easier to use one application instead of two.
It’s not as powerful as a full SQL IDE, but for simple stuff, it’s quite useful.
In this video, you’ll learn how to install the extension in VSCode, how to create a connection to the Oracle database, how to run some SQL queries, and some features of the extension.
Timestamps:
00:00 What we’re doing
01:03 Install the extension
02:19 Create a connection
04:46 Create a table
06:44 Insert some data and view it
07:58 Extension features
08:48 Bookmarks

[@VijayalakshmiAlwar]

I have honestly been strugging with setting up oracle db for days ow. This video saved me honestly!!! Tahnk you sooooo much!!!!

[@DatabaseStar]

Awesome, glad it helped!

[@sreevyshnavi1927]

This made my day! Very clearly explained!

[@DatabaseStar]

Glad it helped!

[@severtone263]

Great video buddy! You earned my sub! Thank you

[@DatabaseStar]

Thanks!

[@yorg33kyorgeek57]

Hi, Do you have experience setting up the ODPNET assemblies as references in VS Code? I would like to be able to reference the ODPNET libraries in a VS Code C# console app/project and interact with oracle tables by SELECTing, INSERTing, and UPDATEing tables/views. Any hints or links to share for setting up ODPNET references in VS Code?

[@DatabaseStar]

Hi, unfortunately I don't have any experience with this...

[@ydoomenaud]

This video and the documentation do not mention that this isn't compatible with SSH Remote and that it won't be fixed until 21.6

[@DatabaseStar]

Thanks for pointing this out! I wasn't aware of it.

[@CaribouDataScience]

How can I set VS CODE so that the output from a query will always appear on the right of the screen?

[@DatabaseStar]

I'm not sure. I think there's a way to snap the panel to the side, but I don't know if that will be the default behaviour.

[@ooogg2610]

Very good video. My only suggestion is that it's very bad practice to connect as SYS and start creating user objects for your App in the SYS schema since that's where Oracle also places its internal tables. The SYS user is basically equivalent to connecting as Root in Linux or SA in SQL Server.. so it also could become a security problem.

[@DatabaseStar]

Thanks! Yes I agree, using the SYS schema is bad for the reasons you mentioned. I only used it because creating a user on Oracle can be hard to do.

[@hadilsherlnans5404]

amazing vedio thanks a lot u helped me a lot

[@DatabaseStar]

Glad it helped!

[@CaribouDataScience]

Thanks that was helpful.

[@DatabaseStar]

Glad it helped!

[@yuliyacher67]

Thank you!

[@DatabaseStar]

You're welcome!

[@hasanmougharbel8030]

Hey there, god bless your efforts in this channel. As a newbie sql learner i have general enquiry. What is the major difference between Oracle database and mysql database. Is there any advantages i need to consider before choosing to work on one of them. Thanks for taking care of this.

[@DatabaseStar]

Thanks! Good question. Oracle is focused on larger organisations and systems, and MySQL is popular with smaller projects and websites. MySQL is free and open-source, and Oracle is not. Most of the SQL syntax is the same, but there are some differences.

[@mathennoel]

Hi. It is showing an error when I click create connection part. What should I do

[@DatabaseStar]

Oh what error are you seeing?

[@lasyamalladi95]

I am getting this error while setting up the connection- Error opening connection 'SYSTEM.XEPDB1'.Details: ORA-12541: TNS: No listener ..Can someone please help me out?

[@DatabaseStar]

Is the database running on the computer/hostname you've specified?

[@kevinelezi7089]

how can I import a cdv database ???? I cannot find the command :(

[@DatabaseStar]

I'm not sure but there may be a way to right click on the database or the table and select Import, then select your file.

[@marouaneouladali2395]

Thank you for this tutorial, i'm just facing an error message that says: ORA-12541: TNS: No listener I hope you can help me with it, thank you again

[@DatabaseStar]

Glad it was helpful! I think that error means the database isn't running. You can run the database using the command line, and I think there's an option in the start menu if you're on Windows. Either that, or the connection details you have entered are not correct.

[@pepealexandre]

Thank you, sir!

[@DatabaseStar]

You’re welcome!

[@dev28014]

Thanks for the video.. can we push oracle database objects to Azure repos using VScode

[@DatabaseStar]

I think you can, you would have the SQL code to create the object in an sql file, and commit that to a repository.

[@dev28014]

@@DatabaseStar thanks for the reply.. will try that

[@teha1306]

thank you!

[@DatabaseStar]

You’re welcome

[@techno-track318]

Why we use blob datatype & how it differ from varbinary datatype plz help....

[@techno-track318]

I need detail explain how reference is going to be stored

[@DatabaseStar]

Good question. BLOB can be used to store large sets of data that aren't always readable as text, such as large files, or even a large amount of text. I'm not sure what the use of VARBINARY would be however.

[@logansimmons3199]

How do I connect to a database on a virtual machine running on my host computer?

[@DatabaseStar]

Which Virtual Machine software are you using? When I've done this in the past, using either Parallels or VirtualBox, I had to look up what the connection details were, and sometimes had to allow the ports to be used between the virtual machine and the host.

[@logansimmons3199]

@@DatabaseStar I'm using VMware player. I've got a Fedora image running on it

[@prajwalkawle1337]

This is all fine but can we do the same with oracle sql developer?

[@DatabaseStar]

Yes you can do this and much more with SQL Developer.

[@jrlopez9612]

What if I'm using a wallet from oracle, how can I connect?

[@DatabaseStar]

Ah I'm not sure, I know there's an option in SQL Developer to do that, but not sure about this VSCode extension.

[@SC-hp5dn]

While trying to create connection I keep getting connection request time out. What could be the reason for this?

[@DatabaseStar]

That’s strange. Does it work if you connect with another editor?

[@SC-hp5dn]

@@DatabaseStar my bad I was making a silly mistake like not connecting to vpn☺️ it’s working now. Thanks for replying

[@abhi1302]

Can we checkin in azure using vs

[@DatabaseStar]

What do you mean by checkin? You can use VS Code with SQL Server using a different extension.

[@neilhutchinson8005]

Probably worth mentioning that Auto Commit is enabled by default in this extension - not everyone will want this. Press F1 > Open Settings > Oracle Developer Tools (under Extensions) > Un-check "Query: Auto Commit" to disable.

[@DatabaseStar]

Thanks for the tip!

[@harshitasharma4034]

any app to download prior?

[@DatabaseStar]

Yes, you'll need Visual Studio Code, but that's all.

[@rommelmitchellvasconezmio8275]

Thanks!!!!!!!!!!!!!!

[@DatabaseStar]

You're welcome!

[@peri0496]

i tried the option describe but dont show nothing

[@DatabaseStar]

Which option describe?

[@Bokie-ow1nc]

how can i get oracle databse on mac ?

[@DatabaseStar]

I've got a video coming out this week that shows you exactly how to do this :)

[@Bokie-ow1nc]

@@DatabaseStar great! Looking forward to it

[@andynelson2340]

2:30 "Cylinder Icon with multiple rings". It's 'disk pack' or DB icon my man 🙂

[@DatabaseStar]

Ah thanks - I wasn't sure what to call it and how to make it sound different from the other one that was there!

[@ahuachapan2]

You have a cool voice.

[@DatabaseStar]

Thanks!

[@nelsonrios627]

i love you

[@DatabaseStar]

Haha thanks!

[@adepusairahul7375]

I am getting white creating connection, ORA-12541: TNS: No listener

[@DatabaseStar]

Is the server running? Are you able to connect with another IDE such as SQL Developer?

[@marcello4258]

Kinda amazing.. yet, this is at least officially - in your other video you showed us a third party tool. As extensions are just plain JS without auditing I don’t feel comfortable placing my credentials in it. Why do you?

[@DatabaseStar]

That's a good point. You could opt not to save your password and enter it every time. Or you could stick with an IDE such as SQL Developer if you're not comfortable with the security of the extension.

[@marcello4258]

@@DatabaseStar I go another route but I am using primarily using vim/tmux so I am fine. Once set up there is not really a reason to go for other products