5071181
9780071484749
Complete Coverage of Oracle's New Free Development ToolEnhance 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 Handbookshows 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 moreHotka, Dan is the author of 'Oracle SQL Developer Handbook', published 2006 under ISBN 9780071484749 and ISBN 0071484744.
[read more]