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

A "quick" overview of our new VS Code extension for the Oracle Database, AND the future of Oracle SQL Developer!
Chapters:
00:02:35 Finding SQL Developer in the VS Code Marketplace
00:04:30 Database Connections
00:06:15 Running Queries
00:07:50 Running Queries via the Command Line (SQLcl)
00:10:10 Opening Database objects...from your code editor
00:11:37 Extension Settings & Preferences
00:12:35 Browsing the dictionary using virtual file system breadcrumbs
00:13:00 Drag & Drop to generate SQL
00:13:22 Code assistance - keywords and object names
00:15:10 SQL History
00:15:40 Peek into PL/SQL definitions
00:16:34 Database Object Context Menus - disabling all Foreign Key Constraints for a table
00:17:07 Filtering - objects and schemas in your connection tree
00:19:50 Text and Visual Explain Plans for your SQL
Resources:
SQL Developer in VS Code Marketplace: marketplace.vi...
Jeff's Blog Posts for SQLDev & VS Code:
www.thatjeffsm...
Oracle SQLcl Overview:
• Oracle SQLcl: Celebrat...

[@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]

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

[@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!

[@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

[@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.