Videos uploaded by user “Oracle Database Development Tools”
Automatic Historical Tracking of Data in Oracle Using Flashback Data Archive
Track data as it changes over time without any code or schema changes in Oracle Database using Flashback Data Archive.
Generating Code Quickly with Oracle SQL Developer
See how in 15 minutes you can generate SQL statements, anonymous PL/SQL blocks to run your programs, get help completing database object names, and re-using frequently used snippets of code or queries in Oracle SQL Developer.
Using Theme Roller with Universal Theme - Oracle Application Express (APEX) 5
See how to quickly change the look and feel of your Oracle Application Express applications. Quickly change or just preview colors for any element of your application, save to a new theme, add custom CSS or HTML, and much more.
3 Oracle SQL Developer Data Modeler Features to Save Time and Make Fewer Mistakes
We'll step you through three of our design tool features that can save you time, and help you from propagating mistakes across your models. Search and Replace Preferred Data Types and Domains Collaboration via Excel
Reverse Engineering your Oracle Database to a Relational Data Model
How to use SQL Developer Data Modeler to import database objects to a data model.
High Performance Bulk Data Loading
What is the best way to get data into an Oracle database? This session covers how to bulk load data quickly into an Oracle database. It will help developers avoid common gotchas that will limit performance, and it gives insight into how to make sure the solution will be database AND DBA-friendly! Example SQL is used to demonstrate the solution, and links to working examples will be provided.
Oracle Database 12c: Simplifying Effective Date Range Queries with Temporal Validity
Fewer mistakes, less typing - in 12c you can define effective date ranges for your table date columns. Chris Saxon provides a quick demo in this week's episode.
Debugging PL/SQL with Oracle SQL Developer
Quick overview of our PL/SQL debugger - required privs, setup, and a demo of stepping through a PL/SQL function. Breakpoints, watches, and call stacks, oh my!
What's New in Oracle SQL Developer version 4.1
Oracle SQL Developer Product Manager Jeff Smith takes you on a tour of the new features in Oracle's IDE and GUI for Oracle Database.
Introduction to node-oracledb: the new Node.js driver for Oracle Database
Want to write highly scalable, event driven applications? Node.js lets you do just that. After a quick introduction to Node.js, this session dives into the features of node-oracledb, the new, open source Node.js driver for Oracle Database, which is under active development.
Loading Data from Excel to Oracle using SQL Developer
How to quickly load data from a spreadsheet or delimited file to a new or existing table in Oracle SQL Developer. Also briefly cover using the same interface for setting up SQL*Loader runs or External (staging) Tables.
Oracle REST Data Services
Overview of Oracle REST Data Services (ORDS) and REST-enabling your database.
Oracle and .NET
How do you get started using Visual Studio to develop .NET web applications that leverage the power of Oracle Database 12c? This beginner-level webcast answers that question and introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by step-demos show you how to get started using each of these free products.
PL/SQL Anti-Patterns with Steven Feuerstein
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”.
Oracle SQL Developer's Tuning Features
An overview of all the performance tuning and diagnostic features in Oracle SQL Developer including: Explain Plan, Autotrace, SQL Tuning Advsior, Real Time SQL Monitoring, ASH, Monitoring Sessions, and our new Instance Viewer.
A New SQL*Plus?
Oracle SQL Developer Product Manager Jeff Smith introduces a new client tool for working with Oracle Database - SQLcl. A command line interface that supports SQL*Plus commands but also brings in more modern features such as table and column name completion, statement recall, and new commands like CTAS, DDL, and a new version of DESC called INFO.
Getting Started with Git for the Oracle Developer
Overview of Git, using in the CLI or with a GUI (SQL Developer), and a look at some Oracle Git projects.
Oracle SQL Developer for the DBA
An overview of Oracle SQL Developer's database administration features.
Coding for High Performance Data Loading in Oracle Database
This session covers how to load data quickly into an Oracle database using clients implemented in languages such as Java, C++, Ruby, Python and PHP. It focuses on scenarios where data arrives continuously and must be made visible and queryable as soon as possible. Java code examples are presented with some Python
Using SQL in Oracle Database 12c to Query Twitter Data stored as JSON
You can use SQL to query JSON as a relational object in Database 12c. This video demonstrates this using Twitter data gathered using their public API.
Oracle Database 12c: SQL Pattern Matching
The new groundbreaking SQL pattern matching capabilities brings the simplicity and efficiency of the most common data analysis language to the process of identifying patterns within a data set. It provides a completely new native SQL syntax that has adopted the regular expression capabilities of Perl by implementing a core set of rules to define patterns in sequences (streams of rows). In this first session will explore some of the main concepts and key words of the new syntax. Subsequent sessions will explore typical use cases for SQL pattern matching and how to debug your pattern matching process.
Fast Load from Hadoop to Oracle Database
Unstructured data (weblogs, social media feeds, sensor data, etc.) is increasingly acquired and processed in Hadoop. Applications need to combine the processed data with structured data in the database for analysis. This session will cover Oracle Loader for Hadoop for high speed load from Hadoop to Oracle Database, from source formats such as Hive tables and weblogs.
Oracle Developer Day Database VirtualBox Appliance
Getting started working with Oracle Database is as easy as downloading this free VirtualBox image and hitting 'start.' This presentation shows how to download, install, and use one of the most popular Oracle Technology Network downloads. 12c, with Multientant and In-Memory options running on Oracle Linux 7 with sample data AND hands-on labs.