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

Von:

Narayanan, Ajith [aut]

Resource type: Ressourcentyp: Buch (Online)Buch (Online)Sprache: Englisch Reihen: Professional expertise distilledVerlag: Birmingham, UK : Packt Publishing, 2016Beschreibung: 1 online resource (1 volume)ISBN:

9781782174714

Weitere Titel:

Learn database design, development, and administration using the feature-rich SQL Developer 4.1 interface

Schlagwörter:

Andere physische Formen: 9781785281273 | Erscheint auch als: 9781785281273 Druck-AusgabeDDC-Klassifikation:

005.756

LOC-Klassifikation:

QA76.73.S67
T55.4-60.8

Online-Ressourcen:

Zugang im Netz des KIT

Zusammenfassung: 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 filesZusammenfassung: 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 WorksheetZusammenfassung: 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 paneZusammenfassung: 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 reportsZusammenfassung: 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 exportingZusammenfassung: Sharing reports through user-defined extensionsPPN: PPN: 86032642XPackage identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE

Exemplare ( 0 )

Dieser Titel hat keine Exemplare