Oracle SQL Developer Handbook

  • 2h
  • Dan Hotka
  • Oracle Press
  • 2007

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

About the Author

Dan Hotka is a Training Specialist who has over 28 years’ experience in the computer industry and over 23 years’ experience with Oracle products. He is an internationally recognized Oracle expert with experience dating back to the Oracle V4.0 days. Dan has co-authored seven popular books including the Database Oracle10g Linux Administration by Oracle Press. He also authored Oracle9i Development by Example and Oracle8i from Scratch by Que. He is frequently published in trade journals, and regularly speaks at Oracle conferences and user groups around the world.

In this Book

  • Oracle SQL Developer Handbook
  • Foreword
  • Introduction
  • Product Installation, Upgrades, and System Requirements
  • Getting Connected
  • Quick Start
  • General Information
  • Working with the Connections Navigator
  • Working with SQL
  • Working with PL/SQL
  • Additional Topics
  • Available Reports
  • User-Defined Reports
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Book Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies