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:

Jeff's Blog Posts for SQLDev & VS Code:

Oracle SQLcl Overview:

[benyu]

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.

[ZafarIqbal]

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

[cathrerinezetadrones]

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

[michastochmal]

Thanks for this video, unfortunately the extension is still missing major features like: possibility to create folders for connections, you can't color connection, filtering is clunky, and there are some useful shortcut bindings missing (like go to declaration), and the thing still not present in classic SQL developer but I would love to see it in VS code - easier binding for Date variables. But it's a step in the right direction :).

[mikemcculley]

Hey I didn't know that Jeff Smith had a channel. Surprised I've never stumbled upon it before. Is there a way to import existing connections from SQL Developer?

[kizhiinez]

Hello Jeff, Thanks for the info! Unfortunately I was not able to make a db connection. I am new to SQL and Oracle so I neither have my own db nor do I have a connection with Oracle. But I did just create an account on Live SQL for my class. How do I begin from scratch?

[JannatMohammed-nmrz]

I can't connect to the database I get this error Cannot read properties of undefined (reading 'links') Please reply

[maaac_Uno]

the result of the query is to right for me, how do you get it on the bottom?

[sandeeptanjore]

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?

[ChaminWork]

Thanks for the detailed video. Is there an option to create tables via GUI ? I couldn't find the option.

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

[daveyt]

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

[NirajKumar-fbsq]

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.

[Faatihahmed]

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.

[Valerio_Costa]

Anyone knows how to use the same object icons of sql developer in the object tree? some theme or plugin or something?

[SidBou]

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