Overview
Start-to-finish coverage of Oracle's new free development tool, from Oracle Press
Here is the first book to offer concise, practical details for installing, setting up, and effectively using Oracle's new free development tool—Oracle SQL Developer. Featuring a Quick Start section and tips and techniques previously not available in print, this Oracle Press guide will help you effectively enhance productivity and simplify database development tasks.
Synopsis
Complete Coverage of Oracle's New Free Development Tool
Enhance productivity and simplify database development tasks using Oracle SQL Developer and the detailed instructions in this Oracle Press guide. Written by experienced Oracle instructor Dan Hotka, Oracle SQL Developer Handbook shows you, step-by-step, how to put every feature of this new and exciting deployment tool to work for you. Inside, you'll learn to set up Oracle SQL Developer, establish database connections, and manage SQL, SQL*Plus, and PL/SQL scripts. Detailed code examples and screenshots illustrate each point along the way.
- Install, configure, upgrade, and maintain Oracle SQL Developer
- Create, import, export, and save database connections
- Customize Oracle SQL Developer's desktop, toolbars, tabs, and windows
- Build and modify SQL objects, tables, and data
- Use the Connections Navigator window to access database objects
- Insert, update, and delete data using the SQL Worksheet interface
- Build packages, procedures, and functions with the PL/SQL Editor interface
- Test and debug PL/SQL code using the PL/SQL Debugger
- Export object definitions and DDL scripts
- Use built-in and user-defined reports for tuning, administration, and more
Dan Hotka is a training specialist who has more than 22 years of experience with Oracle products. He is frequently published in Oracle trade journals and regularly speaks at Oracle conferences and user groups around the world.