You can download Oracle SQL Developer Extension for VSCode Extension from this link marketplace.visualstudio.com/items?itemName=Oracle.sql-developer You can also read the blog for more details www.rebellionrider.com/connect-oracle-with-visual-studio-code/
Thank you so much for the kind words! 😊 It means a lot. Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 🌟
🎉 Happy New Year! 🎉 We're thrilled you're excited about the Oracle SQL Developer Extension for Visual Studio Code! 😃 Have you had a chance to try it out yet? What features are you looking forward to exploring the most? 🚀 #DatabaseTech #NewYearNewTools
During the installation process, a message appears in the bottom left corner stating "Activating Oracle SQL Developer extension for VS Code," but I'm unable to see the DB icon. The Oracle Developer Tools for VS Code (SQL and PLSQL) function properly; I can see the DB icon and connect without any issues. Could you please assist me with this?
Hello! Facing the "The database username or password is incorrect" issue during extension setup on VS Code can be a common challenge. Double-check your credentials, ensuring they match the correct database username and password. Also, confirm that the user has the necessary privileges and that there are no typos. If the problem persists, consider resetting the password or verifying the user's access. Remember, handling authentication details requires caution. I don't take responsibility for any issues arising from password changes. Give it another shot with the correct credentials, and if you encounter further problems, share specific error details for more targeted assistance. Good luck with setting up the extension! 🔐🛠️
I'm sorry to hear you're facing difficulties with the installation. When encountering the "An error occurred resolving or validating database hostname or IP address" message, it might be related to the hostname and port configuration. In Oracle Database, you can locate this information in the "listener.ora" file, usually found in the Oracle Network administration directory. Check the "LISTENER" section for the hostname and port number configuration. The default port is 1521, but it might differ based on your setup. Remember, editing configuration files requires administrative privileges, so approach changes with caution. Please note that I don't take responsibility for any issues that may arise from modifications to the configuration file. If the issue persists, ensure you have the correct privileges and double-check the configurations in the "listener.ora" file. If you have any specific details or error messages, feel free to share them for more targeted assistance. Best of luck with your installation! 🛠️🔍
I see you're having trouble connecting to the database, likely due to an incorrect service name. In Oracle Database, the service name is defined in the "tnsnames.ora" file, usually found in the Oracle Network administration directory. Please check this file for the correct service name. Keep in mind that editing configuration files requires administrative privileges, and any changes should be approached cautiously. Note that I don't take responsibility for any issues arising from modifications. If the problem persists, verify the service name in "tnsnames.ora" and attempt the connection again. Feel free to share specific error messages for more targeted help. Good luck with resolving the connection issue! 🛠️🔗
Hi Sir. I love your videos. Could you please make a video to share how to use Data Miner function in Oracle Developer? I have a trouble when I try to install "Data Miner repository".
Hi Jeff! 👋 Huge thanks to you for creating such an incredible extension! 🚀 Your hard work truly shines through, and it's a pleasure showcasing the value it brings. 🙌 Anything specific you'd like to highlight or share with the community about the extension's development journey? 🌟
Yes we have to install Oracle separately. Here is the video that you can refer for proper installation How To Install Oracle Database 21c on Windows 10/11 by Oracle Ace Manish Sharma ua-cam.com/video/-h2NJmake20/v-deo.html
Absolutely! 🌐 Yes, you can use Git repositories on DevOps for version control in Oracle database development, especially with VS Code. 😊 Have you explored the Git integration features in VS Code for database projects? It's a powerful way to manage versioning and collaborate with your team. Let me know if you need any tips or guidance on setting it up! 🛠️💻
@Rebellionrider I am new to using Git and DevOps, and I am looking for the best practices for that in Oracle Database development and implementing ci/cd. I would appreciate any advice or resources that you can share with me.
👋 Making choices for your future is crucial. If you're looking to upgrade or switch from PL/SQL, consider exploring options like Python or Java for broader opportunities. 🌐 What aspects of PL/SQL do you enjoy, and are there specific technologies you're leaning towards? 🤔
@@Rebellionrider i am interested to choose AWS(data analytics) or AZURE rather than programming languages like Python or Java will it help to get good opportunities?
Absolutely! 🚀 Exploring AWS (data analytics) or Azure is a fantastic choice! 💻 Both cloud platforms offer excellent opportunities, especially in the realm of data analytics. Have you considered acquiring certifications in AWS or Azure to strengthen your profile? 🌐 Let's dive deeper into your interests and chart a path to those exciting opportunities! 🛠️💡
Hello there! 👋 Becoming a PL/SQL developer is a fantastic journey! 🚀 Start by mastering PL/SQL fundamentals, then broaden your skills with SQL, database design, and tuning. 💡 Additionally, learning a programming language like Java or Python can open up more opportunities. 🌐 What specific areas are you most interested in within PL/SQL development? Let's tailor the advice to your goals! 🎯
Appreciate the feedback, buddy! 😊 It's true, sometimes the actual extension documentation might fall short. If you've found the setup explanation helpful, that's what matters! Also, do you have any favorite data analysis tools you'd recommend? Let's keep the knowledge flowing! 🚀📚
You can download Oracle SQL Developer Extension for VSCode Extension from this link
marketplace.visualstudio.com/items?itemName=Oracle.sql-developer
You can also read the blog for more details
www.rebellionrider.com/connect-oracle-with-visual-studio-code/
i never heard such a kind, calm and pleasant Indian voice, KEEP UP THE GOOD WORK!❤
Thank you so much for the kind words! 😊 It means a lot. Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 🌟
Hello Manish, what is the service name and what should it be?
I am getting error a connection with the database could not be installed wt to do now?
same here bro...how do i resolve it?
Happy New Year! Wow! Oracle SQL Developer Extension for Visual Studio Code. This is great news! Thanks for sharing.
🎉 Happy New Year! 🎉 We're thrilled you're excited about the Oracle SQL Developer Extension for Visual Studio Code! 😃 Have you had a chance to try it out yet? What features are you looking forward to exploring the most? 🚀 #DatabaseTech #NewYearNewTools
I haven't set any password before ...!!
Connection error!ORA-00942: table or view does not exist
i am getting this error while connecting
have you imported your related tables/views? you can execute your query of making your tables
During the installation process, a message appears in the bottom left corner stating "Activating Oracle SQL Developer extension for VS Code," but I'm unable to see the DB icon. The Oracle Developer Tools for VS Code (SQL and PLSQL) function properly; I can see the DB icon and connect without any issues. Could you please assist me with this?
once i save the file the sql dev options to save the files goes away and fixes for that?
Hello have tried adding extension on vs code when trying to test the connection it shows (The database username or password is incorrect)
Hello! Facing the "The database username or password is incorrect" issue during extension setup on VS Code can be a common challenge. Double-check your credentials, ensuring they match the correct database username and password.
Also, confirm that the user has the necessary privileges and that there are no typos. If the problem persists, consider resetting the password or verifying the user's access.
Remember, handling authentication details requires caution. I don't take responsibility for any issues arising from password changes.
Give it another shot with the correct credentials, and if you encounter further problems, share specific error details for more targeted assistance. Good luck with setting up the extension! 🔐🛠️
Please I followed your steps to install but it’s telling me . An error occurred resolving or validating database host name or IP address
I'm sorry to hear you're facing difficulties with the installation. When encountering the "An error occurred resolving or validating database hostname or IP address" message, it might be related to the hostname and port configuration.
In Oracle Database, you can locate this information in the "listener.ora" file, usually found in the Oracle Network administration directory. Check the "LISTENER" section for the hostname and port number configuration. The default port is 1521, but it might differ based on your setup.
Remember, editing configuration files requires administrative privileges, so approach changes with caution. Please note that I don't take responsibility for any issues that may arise from modifications to the configuration file. If the issue persists, ensure you have the correct privileges and double-check the configurations in the "listener.ora" file. If you have any specific details or error messages, feel free to share them for more targeted assistance. Best of luck with your installation! 🛠️🔍
When I am doing same but I found error a connection with the database could not be found pl suggest
I see you're having trouble connecting to the database, likely due to an incorrect service name. In Oracle Database, the service name is defined in the "tnsnames.ora" file, usually found in the Oracle Network administration directory. Please check this file for the correct service name.
Keep in mind that editing configuration files requires administrative privileges, and any changes should be approached cautiously. Note that I don't take responsibility for any issues arising from modifications.
If the problem persists, verify the service name in "tnsnames.ora" and attempt the connection again. Feel free to share specific error messages for more targeted help. Good luck with resolving the connection issue! 🛠️🔗
Hi Sir. I love your videos. Could you please make a video to share how to use Data Miner function in Oracle Developer? I have a trouble when I try to install "Data Miner repository".
does this work on mac?
Off course it will
@@Rebellionrider the password you mention I have never had. I have only added this extension to my vscode on m1 macbook
How can we edit values in query result view without writing update scripts?
Hi manish.., i get error like this and i am using MacBook Air. Error: A connection with the database could not be established
same problem with me how to fix it
Thanks Manish!
Hi Jeff! 👋 Huge thanks to you for creating such an incredible extension! 🚀 Your hard work truly shines through, and it's a pleasure showcasing the value it brings. 🙌 Anything specific you'd like to highlight or share with the community about the extension's development journey? 🌟
Do we need to install oracle separately
Yes we have to install Oracle separately. Here is the video that you can refer for proper installation How To Install Oracle Database 21c on Windows 10/11 by Oracle Ace Manish Sharma
ua-cam.com/video/-h2NJmake20/v-deo.html
@@Rebellionrider what the password is supposed to be i am getting error in oracle and mysql workbench it's nothing but access denied
what password do i need to enter while creating the connection in the sql dev. extention ? help !!!!!
The one that you set during the installation of your database
Getting problem in connection how to solve it
how to download and install oracle database in macbook M1
same problem for me.
there is no way to download in ARM-based system
I am using a virtual machine
Can we use the Git repository on (DevOps), for version control to Oracle database development?
Absolutely! 🌐 Yes, you can use Git repositories on DevOps for version control in Oracle database development, especially with VS Code. 😊 Have you explored the Git integration features in VS Code for database projects? It's a powerful way to manage versioning and collaborate with your team. Let me know if you need any tips or guidance on setting it up! 🛠️💻
@Rebellionrider
I am new to using Git and DevOps, and I am looking for the best practices for that in Oracle Database development and implementing ci/cd. I would appreciate any advice or resources that you can share with me.
Manish bro
I also want to upgrade or switch. After plsql for best future what can i choose?
👋 Making choices for your future is crucial. If you're looking to upgrade or switch from PL/SQL, consider exploring options like Python or Java for broader opportunities. 🌐 What aspects of PL/SQL do you enjoy, and are there specific technologies you're leaning towards? 🤔
@@Rebellionrider i am interested to choose AWS(data analytics) or AZURE rather than programming languages like Python or Java
will it help to get good opportunities?
Absolutely! 🚀 Exploring AWS (data analytics) or Azure is a fantastic choice! 💻 Both cloud platforms offer excellent opportunities, especially in the realm of data analytics. Have you considered acquiring certifications in AWS or Azure to strengthen your profile? 🌐 Let's dive deeper into your interests and chart a path to those exciting opportunities! 🛠️💡
bro you take paid mock interviews
Sorry bro no
Sir please let me know how to become a PL SQL developer and what are other skills and language to know along with PL SQL
Hello there! 👋 Becoming a PL/SQL developer is a fantastic journey! 🚀 Start by mastering PL/SQL fundamentals, then broaden your skills with SQL, database design, and tuning. 💡 Additionally, learning a programming language like Java or Python can open up more opportunities. 🌐 What specific areas are you most interested in within PL/SQL development? Let's tailor the advice to your goals! 🎯
@@Rebellionrider Thanks Same my Question
Cool buddy, weird that the eactual extension does not even close to explain this setup.
Appreciate the feedback, buddy! 😊 It's true, sometimes the actual extension documentation might fall short. If you've found the setup explanation helpful, that's what matters! Also, do you have any favorite data analysis tools you'd recommend? Let's keep the knowledge flowing! 🚀📚