In a few minutes watch how SQL Developer can support you in your daily Oracle database tasks including: + writing, tuning, and debugging your SQL and PL/SQL + generate and publish rich reports + design new data models + manage your database objects and security + migrate your 3rd party database objects and data to Oracle RDBMS If you're looking for a more recent, longer video, that would be this https://www.youtube.com/watch?v=EguMf4HbPU8
Views: 216564 Jeff Smith
How to build queries with your mouse versus the keyboard. 2018 Update: If you'd like to see how to convert your Oracle style JOINS to ANSI style (in the FROM vs the WHERE clause) see this post https://www.thatjeffsmith.com/archive/2018/10/query-builder-on-inline-views-and-ansi-joins/
Views: 76361 Jeff Smith
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 26063 Jeff Smith
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 46126 Jeff Smith
In 8 minutes see how to install and run Oracle SQL, Oracle's newest command-line interface for Oracle Database. Featuring an in-line editor, automatic output formatting, statement history/recall, Oracle SQLcl marries the best of Oracle SQL Developer and a modern CLI.
Views: 36600 Jeff Smith
Here are the things I always change when running a new copy of Oracle SQL Developer. It's all about the preferences.
Views: 5402 Jeff Smith
Oracle Product Manager Jeff Smith shows you how to navigate and work with your PLSQL code with fewer clicks and much more efficiency.
Views: 18194 Jeff Smith
A couple of tricks for navigating from an Oracle Database table to its related objects such as indexes and triggers, and back. Plus how to jump to an object from your PL/SQL code.
Views: 1845 Jeff Smith
See how to get execution and explain plans, format and views those plans, use AutoTrace, and Real Time SQL Monitoring for your SQL queries in Oracle SQL Developer.
Views: 3095 Jeff Smith
60 minute overview of the product including a demo. Bookmarks, as this is a LONG Video: 09:32 - Release History 12:38 - Feature List/Summary 17:25 - End of PPT Show, Live Demo The Worksheet 42:27 - Exploring your Schema with the GUI 48:15 - Working with PL/SQL 54:22 - Using the Debugger 59:30 - Reports 1:02:30 - How to find objects
Views: 55272 Jeff Smith
See very quickly how to click to object declarations, test/execute SQL, and use the code outline in Oracle SQL Developer when working with PL/SQl.
Views: 1528 Jeff Smith
Version 4.2 of Oracle SQL Developer makes it very easy to develop and deploy your Oracle REST Data Services for your Oracle Database.
Views: 14848 Jeff Smith
15 minute overview of configuring the data grids in Oracle SQL Developer: manipulating columns, copy and paste tricks, and working with complex data types.
Views: 3131 Jeff Smith
How to find all columns in your Oracle Database by searching on the name.
Views: 6850 Jeff Smith
An 8 minute demo of the debugger - watches, break points, step over and into your code, the call stack and more. All the details including requirements can be found here https://www.thatjeffsmith.com/archive/2015/06/everything-you-ever-wanted-to-know-about-the-plsql-debugger/
Views: 1054 Jeff Smith
Step by step demonstration of taking an excel (or CSV) file and creating a new Oracle table and then loading the data using Oracle SQL Developer. Yes, it's a Wizard. Yes, you can do it. Yes, there are a few places where you want to be careful.
Views: 3186 Jeff Smith
30 minute new feature overview for Oracle SQL Developer versions 18.1, 18.2, and 18.3. This was originally presented at Oracle Open World in San Francisco in October, 2018. 5:35 Jeff Skips all the marketing stuff and jumps into the actual feature demo
Views: 1582 Jeff Smith
Hate uppercase keywords in your SQL or PL/SQL? Love lower cased identifiers? Want the exact opposite? In this video, Oracle SQL Developer product manager Jeff Smith shows how to configure the tool to make your code look the way you want.
Views: 2034 Jeff Smith
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 1761 Jeff Smith
A quick overview of REST, then an introduction of Oracle REST Data Services (ORDS) and how it brings a RESTful access to your Oracle Database.
Views: 8021 Jeff Smith
The Oracle product manager gives you a quick tour of how to use SQL Developer web to build relational diagrams for your existing objects, and generate DDL, SVGs, and data dictionary reports - all in your browser!
Views: 4921 Jeff Smith
Using just SQL and PL/SQL with Oracle REST Data Services, I'll show you how to build a REST API to POST and GET files to and from your Oracle Database. The files are stored in a table as BLOBs. The sample code and slides can be found here: https://www.thatjeffsmith.com/archive/2018/11/building-a-web-service-for-uploading-and-downloading-files-the-video/ You can skip the intro and get straight to the demo: Demo begins at 4:25
Views: 1137 Jeff Smith
How to navigate and find objects in your Oracle SQL Developer Data Modeler diagrams.
Views: 2854 Jeff Smith
Oracle REST Data Services allows you to REST enable your Oracle Database. Now version 17.3 of ORDS makes it easy to generate OpenAPI JSON for documenting those services using Swagger.
Views: 1045 Jeff Smith
How to use the keyboard in Oracle SQLcl to move around the in-line editor, use tab completion, sql history, and even clear the screen.
Views: 1041 Jeff Smith
How to quickly find your relational model table columns and changing their properties all in one fell swoop in Oracle SQL Developer Data Modeler.
Views: 2089 Jeff Smith
Oracle Database Development Web Series is a weeky 1 hour information session. During the session, Oracle Experts will introduce topics ranging from SQL, PL/SQL, JAVA, Node, .NET and how to improve productivity by utilizing Development Tools like SQL Developer, Application Express and much more. Join us every Wednesday at Noon EST. PL/SQL Anti-Patterns We tend to write the same (kind of) code over and over again. Sometimes those patterns are good. Sometimes they are problematic - and then we call them an “anti-pattern”. In this weekly talk (OR WHATEVER YOU CALL IT), Steven will offer up a few anti-patterns, invite attendees to identify the problem, and then shows how to get rid of the “anti”.
Views: 1971 Jeff Smith
If you want to create a new relational model based on an existing database, you can do so using the Data Dictionary Import in Oracle SQL Developer Data Modeler.
Views: 2176 Jeff Smith
How to copy data to the clipboard with the column headers or how to ONLY copy the column headers in Oracle SQL Developer
Views: 2863 Jeff Smith
Oracle SQLcl is our newest command-line interface for the Oracle Database. One of its new commands is INFORMATION - a replacement for the older DESCRIBE command. Learn more about Oracle SQLcl and Download it here - https://www.oracle.com/database/technologies/appdev/sqlcl.html Follow SQLcl on Twitter here- https://twitter.com/oraclesqlcl
Views: 670 Jeff Smith
You may want to have different versions of your diagrams in Oracle SQL Developer Data Modeler. For example, you may want to use Bachman vs Barker notation. This video shows how to create additional displays for your diagrams.
Views: 2348 Jeff Smith
Resetting your Oracle Database user password just got a LOT easier in version 4.2 of SQL Developer. In this video, the product manager shows you JUST how much easier.
Views: 23322 Jeff Smith
A lot of folks love to live in the command line, and Oracle folks are no different. Here's how to do what you want in the command-line without learning how or spending time to properly format your query results.
Views: 1414 Jeff Smith
Oracle SQL Developer Product Manager Jeff Smith shows you how easy it is to get started with the database integrated development environment (IDE). Download, extract, start, and connect in under 5 minutes!
Views: 19164 Jeff Smith