- 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
Almost all the menus are accessible with appropriate keyboard shortcuts. Some of the key features of SQL Developer that can be accessed via keyboard are listed as follows:
- Users can navigate to and invoke all menu items:
- All toolbar functions are accessible through menu items:
- All menus and menu items have unique and functioning mnemonic keys. All the yellow shaded keys in following screenshot give the examples of the existing mnemonic keys:
- All context menus within the navigators and source editor can be invoked:
- Frequently used menu items have unique accelerator keys:
The following functionalities are available in SQL Developer windows. You can do the following:
- Navigate between all open windows, to all nodes within a window or pane, and between tabs in a window
- Set focus in a window or pane
- Invoke all controls within a window or pane, and perform basic operations
- Navigate and update properties in the Property Inspector
- Use Completion Insight and Code Templates in the source editor
- Invoke context-sensitive help topics, navigate to and open all help topics, and navigate between the navigation and viewer tabs
- Open, close, dock, undock, minimize, restore, and maximize the applicable SQL Developer window
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.