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.
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.
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 !!!
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.
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.
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.
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
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.
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?
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.
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.
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 )
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.
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?
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.
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?
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.
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.
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?
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.
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 😭
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.
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.
Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?
Excellent video by the way. Really great information and concisely conveyed.
Glad it was helpful!
The most perfect video i was looking for thanks ❤
Glad it helped!
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.
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.
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 !!!
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.
I'd like to add version control on my packages, how can this be done for oracle through VS Code?
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.
Please help as it shows : A connection with the database could not be established
Is the Oracle database running? Have you entered the correct SID or service name?
Not its not running and i entered correct details only
@@harshitasharma4865 First of all you need to install oracle database 21c express edition and then you can add connection in vs code
Thanks Ben really appreciate your insight on the install and usage of this game changing new Visual Studio code extension 😎😎
No problem, glad it was useful!
Thank you!!!! I set mine up before my head injury and now I can't remember how to start/use it
Glad you liked the video!
may i ask how to import csv into Oracle SQL ? Thanks
I don’t know if that feature has been added yet, but if not, I’m sure they will add it in the future.
I am getting a TLS Handshake error. It appears that we have to import the cacerts from java to this extension sdk. Do you know how to do that?
Oh I've never heard of that actually, so I'm not sure how to do it.
Amazing overview thanks. This seems sufficient as a replacement for the crusty sqldeveloper. I just don't know how you created the oracle db.
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.
Bro can you pleas tell me how to download and set up the oracle express so that the extension will know it 🙏🙏
How can we use the VS code to version control Oracle database development, using Git repository on DevOps?
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.
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
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.
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.
Yeah, I think that's intentional, it's opening an SQL file from within VS Code.
"Error: A connection with the database could not be established" this is what i get. Is there anything i can do to fix this ?
Do the same connection details work in other editors such as SQL developer?
Bro the same error showing can you tell how to download and set up the oracle db so that the extension will know it
Hi is your error resolved?
how can i see table diagram with this ?
I don’t think that feature has been added yet.
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?
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.
for really beginners create connection is really confusing, where can i find hostname or service name?
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.
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 )
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.
Is there an extension for sql databases in VSCode similar to Data Wrangler? Viewer like that for database would be very useful for me.
Oh I'm not sure, I've never used Data Wrangler actually.
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?
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.
@@DatabaseStar thank you doing that now.
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?
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.
Subscribed.. thanks for this..
Is any additional features in this extension which is not available in sql developer app
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.
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?
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.
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 😭
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.
Make video on how to find connection name,username,hostname&password etc details..
Good idea! This can be tricky sometimes.
So this is exclusive to Oracle DB...
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.
What's the password??
It's the same password you use to login to your database using any other editor, or the one you used when you set up the database.