Home
Videos uploaded by user “Jeff Smith”
Oracle SQL Developer Major Feature Demonstration
 
08:10
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
Views: 201394 Jeff Smith
Oracle SQLcl Introduction and Getting Started
 
08:32
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: 31655 Jeff Smith
Oracle SQL Developer: Query Builder Demo
 
08:13
How to build queries with your mouse versus the keyboard.
Views: 66064 Jeff Smith
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 21033 Jeff Smith
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 37316 Jeff Smith
Oracle SQL Developer: You're Doing it Wrong
 
17:12
15 minutes power tips and tricks session where the product manager will how you how you SHOULD be using Oracle's database IDE and GUI.
Views: 19019 Jeff Smith
Oracle SQL Developer 101: A Desktop Tour
 
10:05
A how-to video, showing you around the desktop panels in Oracle Database's IDE and GUI. See how to put stuff where you want, and how to fix the desktop when it becomes a 'mess.'
Views: 3479 Jeff Smith
Oracle SQL Developer Meets SQL*Plus
 
10:30
10 minute overview of Oracle's new command line interface, brought to you by the makers of Oracle SQL Developer.
Views: 57485 Jeff Smith
Debugging PL/SQL with Oracle SQL Developer
 
02:37
Quick 2 minute video showing how to open a PL/SQL program in Oracle SQL Developer and debug it, line by line.
Views: 29569 Jeff Smith
First Things First - Configuring Oracle SQL Developer
 
03:47
Here are the things I always change when running a new copy of Oracle SQL Developer. It's all about the preferences.
Views: 2855 Jeff Smith
Quickly Navigating Between Objects in Oracle SQL Developer
 
03:38
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: 1616 Jeff Smith
Oracle SQL Developer Tips and Tricks Series, Episode 1
 
06:20
Oracle Product Manager Jeff Smith shows you how to navigate and work with your PLSQL code with fewer clicks and much more efficiency.
Views: 17463 Jeff Smith
Announcing Oracle SQL Developer Web!
 
11:27
Oracle SQL Developer is now available in your browser. Oracle Product Manager Jeff Smith gives an overview and a short demonstration of our newest database user interface.
Views: 5303 Jeff Smith
Oracle REST Data Services Development with Oracle SQL Developer
 
16:00
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: 10640 Jeff Smith
An Overview of Oracle SQL Developer Reports
 
10:07
10 minute video with live demo of the reporting feature inside of Oracle SQL Developer.
Views: 1781 Jeff Smith
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 5182 Jeff Smith
Oracle SQL Developer for the DBA
 
05:48
Brief 5 minute overview of Oracle Database administration features in Oracle SQL Developer, including ASH, ADDM, and managing users.
Views: 2539 Jeff Smith
Slow SQL Query? Get the Plan in Oracle SQL Developer!
 
15:38
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: 1574 Jeff Smith
Oracle SQL Developer: Product Demonstration
 
01:04:26
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: 35152 Jeff Smith
A 5 Minute Tour of Oracle SQL Developer
 
06:02
Write queries and interact with results, click into objects and manage them, execute and debug your PL/SQL, write custom reports, model your objects, and migrate from 3rd party databases to Oracle - all with Oracle SQL Developer!
Views: 5606 Jeff Smith
Completion Insight in Oracle SQL Developer v4.0.2
 
03:46
Oracle SQL Developer can automatically suggest the columns, tables, and other object names as you type. This feature has been enhanced in the latest release, version 4.0.2
Views: 4431 Jeff Smith
Oracle SQL Developer: Setup and Configuration
 
09:54
Here's everything I do for the first time I run Oracle SQL Developer, so it looks and works the way I want. I also show how to import connections from a previous install.
Views: 468 Jeff Smith
Working with PL-SQL in Oracle SQL Developer v4.0
 
10:53
How to navigate your PL-SQL, a few options to consider, and working with execution results of your programs in Oracle SQL Developer version 4.0.
Views: 26159 Jeff Smith
How to Import Excel Into Your Database
 
17:23
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: 1517 Jeff Smith
Oracle REST Data Services Product Walk-through and Demonstration
 
59:52
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: 4951 Jeff Smith
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
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: 769 Jeff Smith
3 Tips for Working with PLSQL in Oracle SQL Developer
 
06:33
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: 679 Jeff Smith
Oracle SQL Developer - Code Formatting vs Changing the Code as You Type
 
10:11
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: 1560 Jeff Smith
Generating Swagger Doc for Your Oracle Database RESTful Services
 
15:02
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: 793 Jeff Smith
Oracle SQLcl Demonstration
 
50:45
Overview and product demonstration of Oracle SQLcl - a modern command line interface for Oracle Database. Features include command and object name tab completion, query history, automatic output formatting, and an in-line editor.
Views: 3352 Jeff Smith
Everything You Need to Know about the Data Grids in Oracle SQL Developer
 
15:10
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: 2262 Jeff Smith
Oracle SQL Developer Trick: Split Your Grids
 
02:38
How to see multiple areas of a table at once, by splitting the display of the data grid.
Views: 2739 Jeff Smith
Oracle Database Development Web Series: PL/SQL Anti-Patterns with Steven Feuerstein
 
44:56
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: 1849 Jeff Smith
Oracle SQL Developer Data Modeler: Search & Replace
 
05:48
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: 1638 Jeff Smith
Navigating Your Oracle SQL Developer Data Modeler Diagrams
 
01:01
How to navigate and find objects in your Oracle SQL Developer Data Modeler diagrams.
Views: 2370 Jeff Smith
Reverse Engineer your Database to a Data Model or How to Generate an ERD
 
01:09
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: 1712 Jeff Smith
Oracle SQLcl: Demonstrating all of the Keyboard Shortcuts
 
04:10
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: 816 Jeff Smith
Oracle SQL Developer Web: Demonstrating the Data Modeler
 
09:53
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: 1884 Jeff Smith
Oracle SQL Developer Web: CREATE and EDIT TABLEs
 
13:03
Demonstration of using Oracle SQL Developer Web's GUIs for creating a new table or editing an existing table - all in your browser.
Views: 568 Jeff Smith
Oracle SQL Developer Data Modeler: How to Create a SubView
 
00:59
When dealing with very large designs, consisting of hundreds of tables or entities, a modeler can break the model up into smaller SubViews.
Views: 2526 Jeff Smith
Creating Multiple Displays of your Diagrams in Oracle SQL Developer Data Modeler
 
01:04
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: 1989 Jeff Smith
Copying Data With Column Headers in Oracle SQL Developer
 
00:52
How to copy data to the clipboard with the column headers or how to ONLY copy the column headers in Oracle SQL Developer
Views: 2404 Jeff Smith
PABUG Webinar: Oracle SQL Developer Tips & Tricks
 
01:04:14
Pennsylvania Banner User Group (PABUG) Webinar - tips and tricks for Oracle SQL Developer with Product Manager Jeff Smith and Temple Assistant Director Helen Sanders
Views: 1599 Jeff Smith
Resetting Your Oracle Database Password with Oracle SQL Developer
 
02:43
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: 17239 Jeff Smith
Dragging Files into Oracle SQL Developer
 
00:39
How to open one or more files from your OS by dragging and dropping them into Oracle SQL Developer
Views: 1470 Jeff Smith
Connect to Oracle in less than 5 minutes with SQL Developer
 
05:14
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: 18232 Jeff Smith
Running Your Oracle Queries at the Command Line with Automatic Pretty Printing
 
04:49
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: 1167 Jeff Smith
Quickly Launch an Object Search in Oracle SQL Developer 4 from any selected text
 
00:16
My new favorite 'trick' for Oracle SQL Developer 4 - launch an object search from any highlighted text in an editor using Alt+G
Views: 2289 Jeff Smith
SQLcl Repeat Command
 
00:39
run a command, over and over, refreshing the screen each iteration in our new take on SQL*Plus Created with TechSmith Snagit for Google Chrome™ http://goo.gl/ySDBPJ
Views: 821 Jeff Smith
Oracle SQLcl Starting Up with an A-10 Audio Clip
 
00:19
Brrrrrrrrrrrrrrrrrrp!!!
Views: 414 Jeff Smith