Custom cover image
Custom cover image

Oracle SQL Developer : learn database design, development, and administration using the feature-rich SQL Developer 4.1 interface / Ajith Narayanan

By: Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Professional expertise distilledPublisher: Birmingham, UK : Packt Publishing, 2016Description: 1 online resource (1 volume)ISBN:
  • 9781782174714
Other title:
  • Learn database design, development, and administration using the feature-rich SQL Developer 4.1 interface
Subject(s): Additional physical formats: 9781785281273 | Erscheint auch als: 9781785281273 Druck-AusgabeDDC classification:
  • 005.756
LOC classification:
  • QA76.73.S67
  • T55.4-60.8
Online resources: Summary: Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Getting Started with SQL Developer 4.1 -- 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 filesSummary: Alternative installations of SQL Developer -- Oracle JDeveloper -- Oracle Database 12c -- Troubleshooting -- 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 -- Database certification matrix (Oracle & Third-Party) -- Finding more help -- Summary -- Chapter 2: Database Connections and SQL WorksheetSummary: Working with the Connections navigator -- Opening connections -- Working with database objects -- Display editors -- General display editors -- Working with the display editors -- Using the SQL display editor -- Working with the data grids -- Reviewing other database object nodes -- Working with PL/SQL objects -- Accessing objects you don't own -- Other users -- Synonyms and filters -- Recycle Bin -- Creating new database objects -- Editing database objects - putting context menus to work -- Editing objects -- Script Runner/Running scripts -- Execution plan -- Autotrace pane -- DBMS Output paneSummary: OWA output pane -- Query Builder -- Command-line interface for SQL formatting -- SQL Worksheet ""hints"" for formatting output -- Summary -- Chapter 3: The Power of SQL Reports -- Introducing SQL Developer reports -- Who can run reports? -- When do you use reports? -- Tree layout for ease of navigation -- Running a report -- Privileges required for running reports -- Running data dictionary reports -- Getting to know the data dictionary -- About the database -- Reviewing privileges and security reports -- Assisting with quality assurance -- Using PL/SQL reports -- Running ASH and AWR reportsSummary: Migration reports -- Application Express reports -- Data Modeler reports -- More report categories -- Running reports from other menus -- The Monitor Sessions report -- Managing the database -- Real-time SQL monitoring -- Creating your own reports -- Getting started -- Creating folders -- Storing reports -- Creating general reports -- Building general tabular reports -- Adding bind variables -- Drilling down through reports -- Creating a drill-down report -- Master-detail reports -- Creating master-detail reports -- Adding charts -- Importing and exportingSummary: Sharing reports through user-defined extensionsPPN: PPN: 86032642XPackage identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE
No physical items for this record
KIT – The University in the Helmholtz Association                         Home | Impressum | Datenschutz | Barrierefreiheit | KIT