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.
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.
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?
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?
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.
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.
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.
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
Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?
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!
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!
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.
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.
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?
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.
any app to download prior?
Yes, you'll need Visual Studio Code, but that's all.
Hi. It is showing an error when I click create connection part. What should I do
Oh what error are you seeing?
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
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!
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
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...
Thank you, sir!
You’re welcome!
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.
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.
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.
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.
Thanks that was helpful.
Glad it helped!
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
amazing vedio thanks a lot u helped me a lot
Glad it helped!
i tried the option describe but dont show nothing
Which option describe?
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.
Thank you!
You're welcome!
thank you!
You’re welcome
You have a cool voice.
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?
Thanks!!!!!!!!!!!!!!
You're welcome!
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
i love you
Haha thanks!