- Oracle SQL Developer
- Table of Contents
- Oracle SQL Developer
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Preface
- 1. Getting Started with SQL Developer 4.1
- Preparing your environment
- A quick overview
- Navigating around SQL Developer
- Database certification matrix (Oracle & Third-Party)
- Finding more help
- Summary
- 2. Database Connections and SQL Worksheet
- Working with the Connections navigator
- Working with database objects
- Display editors
- Working with the data grids
- Reviewing other database object nodes
- Creating new database objects
- Editing database objects – putting context menus to work
- Script Runner/Running scripts
- Command-line interface for SQL formatting
- SQL Worksheet "hints" for formatting output
- Summary
- 3. The Power of SQL Reports
- Introducing SQL Developer reports
- Creating your own reports
- DB Doc generation
- Summary
- 4. Working with PL/SQL
- 5. SQL Developer for DBAs
- Database instance viewer
- Finding database objects
- Database configuration – initialization parameters
- Automatic undo management
- Current database properties
- Restore points
- Data Pump
- Export Jobs
- Import Jobs
- Performance
- Snapshots (filtered)
- Baselines
- Baseline templates
- Automatic Database Diagnostic Monitor (ADDM)
- ASH Report Viewer
- AWR
- RMAN Backup/Recovery
- Resource manager
- Consumer group mappings
- Consumer groups
- Plans
- Settings
- Statistics
- Scheduler
- Global Attributes
- Job Classes
- External Destinations
- Security
- Audit Settings
- Profiles
- Roles
- Users
- Storage
- Archive Logs
- Control Files
- Datafiles
- Redo Log Groups
- Rollback Segments
- Tablespaces
- Temporary Tablespace Groups
- Summary
- 6. SQL Developer Accessibility
- Screen reader readability
- Keyboard access
- Font and color choices
- No audio-only feedback
- Screen magnifier usability
- Change the editor or tabbed view of a file
- Read text in a multi-line edit field
- Read the line number in the source editor
- Customize the accelerators keys
- The look and feel of SQL Developer
- Customize syntax highlighting
- Display line numbers in Code Editor
- Timing for completion insight
- Specify the columns in the Debugger
- Summary
- 7. Importing, Exporting, and Working with Data
- 8. Database Connections and JDBC Drivers
- 9. Introducing SQL Developer Data Modeler
- Oracle SQL Developer Data Modeler
- Getting started
- Working with diagrams and their components
- Analysis, design, and generation
- Summary
- 10. Extending SQL Developer
- Introducing extensibility
- Working with extensions
- Summary
- 11. Working with Application Express
- 12. Working with SQL Developer Migrations
- 13. Oracle Data Miner 4.1
- 14. REST Data Services and REST Development
- Index
One of our more popular features is DB Doc. We can generate an HTML documentation selected schema with a right-click.
You can generate a documentation about your schema in the HTML format for your own review or to share with others. Follow these steps to generate and view schema documentation:
- Connect to the HR schema.
- Right-click on the HR_ORCL connection and select Generate DB Doc.
- Select or create a suitable location for the generated files.
- An
index.htmlfile should open automatically in your default browser. If it doesn't, navigate in a browser to theworkingindex.htmlfile and open it.
To see the details for any database object in the HTML documentation, select the object type in the schema panel in the top left corner. A list of all the objects of that type will then appear in a panel below the schema panel.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.