Oracle SQL Developer 2.1 [[electronic resource] /] / Sue Harper

• Autore: Harper Sue
• Pubblicazione: Birmingham, UK, : Packt Pub., c2009
• Descrizione fisica: 1 online resource (496 p.)
• Disciplina: 005.75/65
• Soggetto topico: SQL (Computer program language); Database design
• Note generali: Includes index.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: 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
• Sommario/riassunto: Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook
• Titolo autorizzato: Oracle SQL Developer 2.1
• ISBN: 1-282-45155-3; 9786612451553; 1-84719-627-6
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910780786403321
• Lo trovi qui: Univ. Federico II