Getting Started and Overview for Oracle SQL Developer extension for VS Code

[@benyu8704]

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.

[@JeffSmiththat]

Thanks! We're reading our next update now, and will offer even more features, stay tuned!

[@ZafarIqbal9922]

اس ایکسٹینشن کو میں نے وی ایس کوڈ میں استعمال نہیں کیا تھا۔ لیکن آپ نے بہت اچھی وضاحت کی ہے تو سب سمجھ آ گیا ہے۔ شکریہ

[@JeffSmiththat]

آپ کی رائے کا شکریہ! مجھے خوشی ہے کہ آپ نے یہ مفید پایا۔

[@sandeeptanjore1253]

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?

[@JeffSmiththat]

very soon, yes

[@cathrerinezetadrones3169]

I would love better support for git with oracle and this seems like the perfect place to improve it

[@JeffSmiththat]

We have a lot planned in this area, stay tuned!

[@GuerreroSUD]

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?

[@JeffSmiththat]

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)

[@MilanPetrovicM]

Looks awesome!

[@JeffSmiththat]

Thanks Milan! Let me know if you have any questions!

[@daveyt88]

Thank you for the video! Is possible to import connections from SQL Developer?

[@JeffSmiththat]

Yes! Follow the steps here: www.thatjeffsmith.com/archive/2024/01/how-to-import-connections-from-sql-developer-to-vs-code/

[@NirajKumar-fb7sq]

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.

[@NirajKumar-fb7sq]

using SqlPlus command terminal i can't access the data and vice-versa.

[@JeffSmiththat]

Did you COMMIT your INSERTs?

[@NirajKumar-fb7sq]

@@JeffSmiththat yes sir now it's working. Thankyou

[@siddharthbouddha]

it can't filter data from the result sheet :(

[@JeffSmiththat]

not YET - for the moment, rerun the query with the desired WHERE or HAVING clauses

[@rodneychan1227]

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 (kzbin.info/www/bejne/m17cop5_ZdlpmrM) - 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.

[@JeffSmiththat]

No, that's something we're currently working on, and are going to release later this year.