Cargando…
Oracle SQL Developer : learn database design, development, and administration using the feature-rich SQL Developer 4.1 interface /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
2016.
|
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- 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 files; Alternative installations of SQL Developer; Oracle JDeveloper
- Oracle Database 12cTroubleshooting; 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 Worksheet; Working with the Connections navigator; Opening connections; Working with database objects; Display editors
- General display editorsWorking 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 pane; OWA output pane; Query Builder; Command-line interface for SQL formatting; SQL Worksheet ""hints"" for formatting output; Summary
- Chapter 3: The Power of SQL ReportsIntroducing 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 reports; Migration reports; Application Express reports; Data Modeler reports; More report categories; Running reports from other menus; The Monitor Sessions report
- Managing the databaseReal-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 exporting; Sharing reports through user-defined extensions; DB Doc generation; Summary; Chapter 4: Working with PL/SQL; Creating, compiling, and debugging PL/SQL; Writing PL/SQL in the SQL Worksheet; Using code insight