Thanks Jeff for the very informative introduction. The Oracle SQL Developer extension for VS Code is getting better and better. The integration of query window with sqlcl terminal is really exciting.
Hello Jeff - Thanks for the teaser or information presented about integrating Oracle with VS code. Just wondering if we can use this extension in VS code to debug anonymous blocks or a package/procedure/function? The way we use TOAD or PL/SQL Developer IDE to debug an object, can the same be accomplished by installing the Oracle SQL , PL/SQL extension on VS code?
Thanks jeff, I try to use new extension is awesome. One feature i used most is in the old one is when the query result is shown I copy it and past to excel and i try to do same senior and didn’t work. How i can do that? Sorry my English is not good.
No apologies necessary, your English was just fine, I know exactly what you mean. I have 2 JIRA tickets in the queue now that directly address this request. I'm hoping it happens for our December update.
We're publishing an update (maybe this week??) where you'll get extension settings to set formatter rules, including how to treat case for keywords (and identifiers)
Hello Jeff sir, I installed Oracle database 21c and Oracle SQL developer 23.1.1 but after creating table & inserting data in Oracle SQL developer 23.1.1, I could not be able to see it through Oracle database 21c. please help me why this is happening.
I noticed in another video introducing VS code Oracle Developer extension you can drag and drop a database connection detail into a python notebook file and code was auto generated (th-cam.com/video/e-yqkI0t6dQ/w-d-xo.html) - Is there a setting somewhere I need to configure to allow this to happen? As I just tried this and wasnt able to get it to work.
Thanks Jeff for the very informative introduction. The Oracle SQL Developer extension for VS Code is getting better and better. The integration of query window with sqlcl terminal is really exciting.
Thanks! We're reading our next update now, and will offer even more features, stay tuned!
اس ایکسٹینشن کو میں نے وی ایس کوڈ میں استعمال نہیں کیا تھا۔ لیکن آپ نے بہت اچھی وضاحت کی ہے تو سب سمجھ آ گیا ہے۔ شکریہ
آپ کی رائے کا شکریہ! مجھے خوشی ہے کہ آپ نے یہ مفید پایا۔
I would love better support for git with oracle and this seems like the perfect place to improve it
We have a lot planned in this area, stay tuned!
Hello Jeff - Thanks for the teaser or information presented about integrating Oracle with VS code. Just wondering if we can use this extension in VS code to debug anonymous blocks or a package/procedure/function? The way we use TOAD or PL/SQL Developer IDE to debug an object, can the same be accomplished by installing the Oracle SQL , PL/SQL extension on VS code?
very soon, yes
Thank you for the video! Is possible to import connections from SQL Developer?
Yes! Follow the steps here:
www.thatjeffsmith.com/archive/2024/01/how-to-import-connections-from-sql-developer-to-vs-code/
Thanks jeff, I try to use new extension is awesome. One feature i used most is in the old one is when the query result is shown I copy it and past to excel and i try to do same senior and didn’t work. How i can do that?
Sorry my English is not good.
No apologies necessary, your English was just fine, I know exactly what you mean. I have 2 JIRA tickets in the queue now that directly address this request. I'm hoping it happens for our December update.
@ waiting that feature then I will migrate to the new extension. Thanks sir.
Hello Jeff, the extension is excelent, but.. How do I make it so that when I format the SQL document, the keywords are in uppercase?
We're publishing an update (maybe this week??) where you'll get extension settings to set formatter rules, including how to treat case for keywords (and identifiers)
Looks awesome!
Thanks Milan! Let me know if you have any questions!
I can't connect to the database I get this error Cannot read properties of undefined (reading 'links') Please reply
Please show exactly what you're doing and the entire error message.
or start a thread on our forums - forums.oracle.com/ords/apexds/domain/dev-community/category/sqldev-for-vscode
Very nice tool. I like it. thank you
Thanks, Adam! We have even more features and improvements coming soon!
Anyone knows how to use the same object icons of sql developer in the object tree? some theme or plugin or something?
Use them where?
Hello Jeff sir, I installed Oracle database 21c and Oracle SQL developer 23.1.1 but after creating table & inserting data in Oracle SQL developer 23.1.1, I could not be able to see it through Oracle database 21c. please help me why this is happening.
using SqlPlus command terminal i can't access the data and vice-versa.
Did you COMMIT your INSERTs?
@@JeffSmiththat yes sir now it's working. Thankyou
I noticed in another video introducing VS code Oracle Developer extension you can drag and drop a database connection detail into a python notebook file and code was auto generated (th-cam.com/video/e-yqkI0t6dQ/w-d-xo.html) - Is there a setting somewhere I need to configure to allow this to happen? As I just tried this and wasnt able to get it to work.
No, that's something we're currently working on, and are going to release later this year.
it can't filter data from the result sheet :(
not YET - for the moment, rerun the query with the desired WHERE or HAVING clauses