This tutorial shows you how to use the DBMS Scheduler feature in Oracle SQL Developer 3.0
This tutorial shows you how to use the SQL Tuning Advisor feature in Oracle SQL Developer 3.0.
This tutorial shows you how to add XML extensions to Oracle SQL Developer.
This tutorial demonstrates some of the PL/SQL features within Oracle SQL Developer, such as advanced searches and refactoring code.
This tutorial shows how to use the source code control feature in Oracle SQL Developer 3.0
In this OBE, you learn how to display and customize query results. You learn how to control the column display in the data grid, selectively hide and show columns, determine the order of the column display, filter columns, highlight data values, and save the data grid in a report.
In SQL Developer 3.0, the DBA Navigator is a new feature. This tutorial focuses on several of the DBA Navigator features, including database usage, intialization parameters, auditing, roles, privileges, and storage information.
In this tutorial, you learn how to use the Query Builder feature to graphically and intuitively build your queries.
This tutorial introduces Oracle SQL Developer 3.0 and shows you how to manage your database objects.
This tutorial focuses on creating, compiling, running and debugging PL/SQL.
This tutorial shows you how to migrate a Microsoft Access database to Oracle Database 11g using Oracle SQL Developer 3.0.
Oracle REST Data Services (ORDS) is a free tool that enables users to turn their Oracle databases into RESTful API Services that are highly scalable, manageable, and secure. With this Getting Started with ORDS, users will learn how to install ORDS, AutoREST Enable tables to display data in JSON, define REST points to INSERT, UPDATE and DELETE data and how to test your RESTful service.
This Lab series includes the following OBEs and must be done in sequential order. A virtual image is available with the environment setup to run these labs. Please go here to download: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
The REST Development in SQL Developer 4.1 provides users with the full capabilities of REST. REST endpoints can be defined along with basic operations including create, query, update and delete. More complex SQL and PL/SQL operations can be defined and mapped. The results can be displayed in JSON and other formats.
Insert, Update, and Delete Data Using RESTful Services is lab #4 in the Getting Started with Oracle REST Data Services Series. Make sure to complete the previous labs in the series before starting on this one.
In this lab you will be going through the following:
* Retrieve information from tables based on a parameter using GET method. * Insert data into Employees table using PUT method. * Update data in Departments table using POST method. * Delete data from Departments table using DELETE method.