After you install the jdbc driver, you can connect to a third party database. This demo will show how to connect to...After you install the jdbc driver, you can connect to a third party database. This demo will show how to connect to a Sybase database in SQL Developer.More
The Oracle NoSQL Database is a horizontally scaled, Key-Value database for Web Services and Cloud, designed...The Oracle NoSQL Database is a horizontally scaled, Key-Value database for Web Services and Cloud, designed specifically to provide highly reliable, scalable and available data storage across a configurable set of systems that function as storage nodes. Oracle NoSQL Database provides a powerful and flexible transaction model that greatly simplifies the process of developing a NoSQL-based application. It scales horizontally with high availability and transparent load balancing even when dynamically adding new capacity.More
This demo will show how to create a migration repository in Oracle SQL Developer. The migration repository is a...This demo will show how to create a migration repository in Oracle SQL Developer. The migration repository is a database schema that stores the meta data collected and transformed in the migration process.More
Join Oracle Corporation luminaries Andy Mendelsohn, Tom Kyte, and Steven Feuerstein as they share their thoughts...Join Oracle Corporation luminaries Andy Mendelsohn, Tom Kyte, and Steven Feuerstein as they share their thoughts about the longevity of SQL, what's amazing about SQL, and why SQL is here to stay.More
To connect to a third party database in SQL Developer, you will need to install a jdbc driver. The drivers are free...To connect to a third party database in SQL Developer, you will need to install a jdbc driver. The drivers are free downloads.More
This demo will show how to create a migration repository in Oracle SQL Developer. The migration repository is a...This demo will show how to create a migration repository in Oracle SQL Developer. The migration repository is a database schema that stores the meta data collected and transformed in the migration process.More
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and...One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio.More
Visualize the status of your database in a brand new, graphical representation of the IO, wait events, storage, log...Visualize the status of your database in a brand new, graphical representation of the IO, wait events, storage, log switches, and processes. Requiring no server side objects, agents, or database changes, this new SQL Developer feature will shorten the amount of time it takes to diagnose ongoing performance issues. From the main page, DBAs and power users can quickly drill down into various activity reports to see the details. NOTE: This is a video only. There is no audio.More
SQL Developer 4.1 now offers multi-cursor editing, remembering frequently used files and directories in open and...SQL Developer 4.1 now offers multi-cursor editing, remembering frequently used files and directories in open and save file dialogs, and verbose SQL recording for all statements sent to the database.More
Every VARCHAR2(N) Declaration a Bug!?
That's right. VARCHAR2 declarations mean that you have to provide an "N" or...Every VARCHAR2(N) Declaration a Bug!?
That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem.More