Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle SQL Developer
  • Table Of Contents Toc
Oracle SQL Developer

Oracle SQL Developer

By : Ajith Narayanan, Susan Harper
3 (1)
Buy this Book
close
close
Oracle SQL Developer

Oracle SQL Developer

3 (1)
By: Ajith Narayanan, Susan Harper
Buy this Book

Overview of this book

At times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility. You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.
Table of Contents (16 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Getting Started with SQL Developer 4.1
Icon
1. Getting Started with SQL Developer 4.1
Icon
Preparing your environment
Icon
A quick overview
Icon
Navigating around SQL Developer
Icon
Database certification matrix (Oracle & Third-Party)
Icon
Finding more help
Icon
Summary
2
2. Database Connections and SQL Worksheet
Icon
2. Database Connections and SQL Worksheet
Icon
Working with the Connections navigator
Icon
Working with database objects
Icon
Display editors
Icon
Working with the data grids
Icon
Reviewing other database object nodes
Icon
Creating new database objects
Icon
Editing database objects – putting context menus to work
Icon
Script Runner/Running scripts
Icon
Command-line interface for SQL formatting
Icon
SQL Worksheet "hints" for formatting output
Icon
Summary
3
3. The Power of SQL Reports
chevron up
Icon
3. The Power of SQL Reports
Icon
Introducing SQL Developer reports
Icon
Creating your own reports
Icon
DB Doc generation
Icon
Summary
4
4. Working with PL/SQL
Icon
4. Working with PL/SQL
Icon
Creating, compiling, and debugging PL/SQL
Icon
Summary
5
5. SQL Developer for DBAs
Icon
5. SQL Developer for DBAs
Icon
Database instance viewer
Icon
Finding database objects
Icon
Database configuration – initialization parameters
Icon
Automatic undo management
Icon
Current database properties
Icon
Restore points
Icon
Data Pump
Icon
Export Jobs
Icon
Import Jobs
Icon
Performance
Icon
Snapshots (filtered)
Icon
Baselines
Icon
Baseline templates
Icon
Automatic Database Diagnostic Monitor (ADDM)
Icon
ASH Report Viewer
Icon
AWR
Icon
RMAN Backup/Recovery
Icon
Resource manager
Icon
Consumer group mappings
Icon
Consumer groups
Icon
Plans
Icon
Settings
Icon
Statistics
Icon
Scheduler
Icon
Global Attributes
Icon
Job Classes
Icon
External Destinations
Icon
Security
Icon
Audit Settings
Icon
Profiles
Icon
Roles
Icon
Users
Icon
Storage
Icon
Archive Logs
Icon
Control Files
Icon
Datafiles
Icon
Redo Log Groups
Icon
Rollback Segments
Icon
Tablespaces
Icon
Temporary Tablespace Groups
Icon
Summary
6
6. SQL Developer Accessibility
Icon
6. SQL Developer Accessibility
Icon
Screen reader readability
Icon
Keyboard access
Icon
Font and color choices
Icon
No audio-only feedback
Icon
Screen magnifier usability
Icon
Change the editor or tabbed view of a file
Icon
Read text in a multi-line edit field
Icon
Read the line number in the source editor
Icon
Customize the accelerators keys
Icon
The look and feel of SQL Developer
Icon
Customize syntax highlighting
Icon
Display line numbers in Code Editor
Icon
Timing for completion insight
Icon
Specify the columns in the Debugger
Icon
Summary
7
7. Importing, Exporting, and Working with Data
Icon
7. Importing, Exporting, and Working with Data
Icon
Exporting data
Icon
Importing data
Icon
Summary
8
8. Database Connections and JDBC Drivers
Icon
8. Database Connections and JDBC Drivers
Icon
Working with Oracle connections
Icon
Creating non-Oracle database connections
Icon
Summary
9
9. Introducing SQL Developer Data Modeler
Icon
9. Introducing SQL Developer Data Modeler
Icon
Oracle SQL Developer Data Modeler
Icon
Getting started
Icon
Working with diagrams and their components
Icon
Analysis, design, and generation
Icon
Summary
10
10. Extending SQL Developer
Icon
10. Extending SQL Developer
Icon
Introducing extensibility
Icon
Working with extensions
Icon
Summary
11
11. Working with Application Express
Icon
11. Working with Application Express
Icon
Setting the scene
Icon
Summary
12
12. Working with SQL Developer Migrations
Icon
12. Working with SQL Developer Migrations
Icon
Introducing SQL Developer Migrations
Icon
Setting up your environment
Icon
Migrating
Icon
Summary
13
13. Oracle Data Miner 4.1
Icon
13. Oracle Data Miner 4.1
Icon
Data source node
Icon
JSON data type
Icon
The APIs for data mining
Icon
Summary
14
14. REST Data Services and REST Development
Icon
14. REST Data Services and REST Development
Icon
About Oracle REST Data Services
Icon
The Oracle REST Data Services Administration toolbar and context menu
Icon
About RESTful services
Icon
Summary
15
Index
Icon
Index

Summary

SQL Developer provides the ability to create and save SQL queries as reports. You can create your own reports using various report styles, including graphs or master-detail reports with sibling detail reports. In addition to being able to create your own reports, SQL Developer supplies a set of shipped reports that access the data dictionary and provide you with an easy start to assessing the status of your application. In this chapter, you saw that by using these SQL reports, you can determine the general health and status of all of the database aspects of the systems you are working with, including the general health of the database, the database objects, and instance data in the application. Using SQL Developer, you can build your own reports and export them to be shared with colleagues by sharing the exported XML file or through the user-defined extension mechanism.

In the next chapter, we'll look at how SQL Developer supports working with PL/SQL Tuning Tools. You'll...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle SQL Developer
End of Chapter 3
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon