Oracle SQL Developer 2.1 / Sue Harper.

Format:

Book

Author/Creator:

Harper, Sue.

Series:

From technologies to solutions

Language:

English

Subjects (All):

Oracle (Computer file).

SQL (Computer program language).

Database design--Software.

Database design.

Physical Description:

1 online resource (496 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, UK : Packt Pub., c2009.

Language Note:

English

Biography/History:

Harper Susan: Sue Harper was a senior school mathematics and science teacher by profession. It was this teaching qualification that opened the door to Oracle in South Africa, where Sue started as a SQL, PL/SQL, SQL Forms, and Reports instructor in 1992. Before long she'd added Oracle Designer to her repertoire and soon left for the UK, to join the Designer curriculum development team. Sue was a course writer and then product manager for Oracle Designer for many years, traveling extensively meeting customers and training Oracle staff and instructors. Sue was later product manager for Oracle JDeveloper working with database and modeling tools in that product. Sue is currently product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations. Based at home, Sue works with her team, scattered around the world and customers, running web-based training sessions or helping with individual queries. She frequently attends conferences where she presents SQL Developer material and works with customers on their queries. Sue lives in West London, where she enjoys walking with her camera and her dog in the extensive local parks and further afield throughout the UK.

Summary:

Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting Started with SQL Developer; Preparing your environment; Finding and downloading the software; Downloading and installing the Java Development Kit; Installing and starting SQL Developer; Working with different platforms; Migrating settings from a previous release; Maintaining your environment; Verifying the current release; Using Check for Updates; Managing the system folder and other files; Sharing preferences; Alternative installations of SQL Developer; Oracle JDeveloper

Oracle Database 11gTroubleshooting; A quick overview; Sample schemas; Creating your first connection; Using basic commands in the SQL Worksheet; Browsing and updating data; Running reports; Navigating around SQL Developer; Managing SQL Developer windows; Tiling windows; Splitting documents; Maximizing detail; Resetting the window layout; Finding more help; Summary; Chapter 2: Browsing and Editing Database Objects and Data; Browsing objects; Working with the Connections navigator; Opening connections; Working with objects; Filtering objects; Display editors; General display editors

Working with the display editorsUsing the SQL display editor; Working with the data grids; Controlling the column display; Sorting the data; Filtering columns; More data grid context menus; Count Rows and the Single Record View; Working with Updating Data Grids; Updating data; Reviewing other database object nodes; Accessing objects you don't own; Recycle Bin; Creating and updating database objects; Creating new objects; Creating tables; Creating views; Reviewing a few specific objects; Editing objects: Putting context menus to work; Editing objects; Diving into context menus

Using context menus as utilitiesSummary; Chapter 3: Working with the SQL Worksheet; Introducing the SQL Worksheet; Controlling the environment; Opening SQL Worksheets; Working with multiple worksheets; Switching connections; Getting started; Writing and executing commands; Writing your first statements; Running statements; Run script; Using SQL*Plus commands; Supporting SQL*Plus; Running scripts; Reviewing unsupported SQL*Plus commands; Working with SQL; Dragging and dropping tables to create queries; Formatting code; Managing the case; Formatting SQL for use in other languages

Working with code completion insightIncluding code snippets; Using the File navigator; Opening files; Using extra features in the worksheet; SQL History; DBMS Output; OWA Output; Using the Query Builder; Building an SQL query; Selecting the tables, column, and joins; Viewing the Results; Adding the WHERE clause; Returning to the SQL Worksheet; Summary; Chapter 4: The Power of SQL Reports; Introducing SQL Developer reports; Who can run reports?; When do you use reports?; Running a report; Using bind variables; Privileges required for running reports; Switching users; Browsing shipped reports

Running data dictionary reports

Notes:

Includes index.

Includes bibliographical references and index.

ISBN:

9786612451553

9781282451551

1282451553

9781847196279

1847196276

OCLC:

797916763