Use VSCode with Oracle Database
Vložit
- čas přidán 20. 07. 2024
- 📝 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 - Věda a technologie
This made my day!
Very clearly explained!
Glad it helped!
I have honestly been strugging with setting up oracle db for days ow. This video saved me honestly!!! Tahnk you sooooo much!!!!
Awesome, glad it helped!
Great video buddy! You earned my sub! Thank you
Thanks!
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.
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.
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
Thanks for pointing this out! I wasn't aware of it.
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.
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.
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?
Hi, unfortunately I don't have any experience with this...
Thanks that was helpful.
Glad it helped!
How can I set VS CODE so that the output from a query will always appear on the right of the screen?
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.
Thank you!
You're welcome!
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.
Thanks for the tip!
amazing vedio thanks a lot u helped me a lot
Glad it helped!
thank you!
You’re welcome
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
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.
Thanks for the video.. can we push oracle database objects to Azure repos using VScode
I think you can, you would have the SQL code to create the object in an sql file, and commit that to a repository.
@@DatabaseStar thanks for the reply.. will try that
Thank you, sir!
You’re welcome!
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?
Is the database running on the computer/hostname you've specified?
Hi. It is showing an error when I click create connection part. What should I do
Oh what error are you seeing?
Why we use blob datatype & how it differ from varbinary datatype plz help....
I need detail explain how reference is going to be stored
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.
How do I connect to a database on a virtual machine running on my host computer?
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.
@@DatabaseStar I'm using VMware player. I've got a Fedora image running on it
This is all fine but can we do the same with oracle sql developer?
Yes you can do this and much more with SQL Developer.
Thanks!!!!!!!!!!!!!!
You're welcome!
how can I import a cdv database ???? I cannot find the command :(
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.
While trying to create connection I keep getting connection request time out. What could be the reason for this?
That’s strange. Does it work if you connect with another editor?
@@DatabaseStar my bad I was making a silly mistake like not connecting to vpn☺️ it’s working now. Thanks for replying
What if I'm using a wallet from oracle, how can I connect?
Ah I'm not sure, I know there's an option in SQL Developer to do that, but not sure about this VSCode extension.
2:30 "Cylinder Icon with multiple rings". It's 'disk pack' or DB icon my man 🙂
Ah thanks - I wasn't sure what to call it and how to make it sound different from the other one that was there!
Can we checkin in azure using vs
What do you mean by checkin? You can use VS Code with SQL Server using a different extension.
i tried the option describe but dont show nothing
Which option describe?
any app to download prior?
Yes, you'll need Visual Studio Code, but that's all.
how can i get oracle databse on mac ?
I've got a video coming out this week that shows you exactly how to do this :)
@@DatabaseStar great! Looking forward to it
You have a cool voice.
Thanks!
i love you
Haha thanks!
I am getting white creating connection, ORA-12541: TNS: No listener
Is the server running? Are you able to connect with another IDE such as SQL Developer?
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?
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.
@@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