Oracle SQL developer learn database design, development, and administration using the feature-rich SQL developer 4.1 interface
Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interface About This Book Explore all the SQL Developer 4.1 features useful for Oracle database developers, architects, and administrators Understand how this free tool from Oracle has evolved over the yea...
| Other Authors: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Birmingham :
Packt Publishing
2016.
|
| Edition: | 1st edition |
| Series: | Professional expertise distilled.
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630210806719 |
Table of Contents:
- 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
- Using code snippets and code templates
