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

Sdílet
Vložit
  • čas přidán 8. 05. 2024
  • 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.visualstudio.com/...
    Jeff's Blog Posts for SQLDev & VS Code:
    www.thatjeffsmith.com/archive...
    Oracle SQLcl Overview:
    • Oracle SQLcl: Celebrat...
  • Věda a technologie

Komentáře • 12

  • @benyu8704
    @benyu8704 Před měsícem +2

    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
      @JeffSmiththat  Před měsícem

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

  • @ZafarIqbal9922
    @ZafarIqbal9922 Před měsícem +1

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

    • @JeffSmiththat
      @JeffSmiththat  Před měsícem

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

  • @cathrerinezetadrones3169
    @cathrerinezetadrones3169 Před měsícem +2

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

    • @JeffSmiththat
      @JeffSmiththat  Před měsícem +3

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

  • @MilanPetrovicM
    @MilanPetrovicM Před měsícem +1

    Looks awesome!

    • @JeffSmiththat
      @JeffSmiththat  Před měsícem

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

  • @daveyt88
    @daveyt88 Před měsícem +1

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

    • @JeffSmiththat
      @JeffSmiththat  Před měsícem +2

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