EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

SQL Manager for Oracle - User's Manual

Contents

Welcome to SQL Manager for Oracle!
What's new
System requirements
Feature Matrix
Installation
Registration
How to register SQL Manager
Version history
EMS SQL Manager FAQ
Getting Started
Selecting style and language
First time started
Using Desktop Panel
Database navigation
Working with database objects
Using context menus
DB Group context menu
Database context menu
Object context menu
Working with windows
Database Explorer
Managing database registration info
Connecting to databases
Operations with database objects
Selecting multiple objects
Using tabs for database navigation
Recently opened objects
Managing projects
Searching within the tree
SQL Assistant
Configuring Database Explorer
Managing Favorite queries
Database Management
Create Database Wizard
Specifying database name
Specifying memory parameters
Defining additional settings
Defining database directories
Data storage and redo log settings
Creating database scripts
Register Database Wizard
Setting connection parameters
Specifying tunneling parameters
Selecting databases
Setting specific options
Database Registration Info
Connection
Options
Display options
Default directories
Logs
SSH tunneling options
Data options
Find Option
Local Naming Parameters Editor
Using Navigation bar and Toolbar
TNS File Constructor
Viewing file contents
Profile Parameters Editor
General options
Naming options
Oracle Advanced Security
Authentication
Integrity and Encryption
TCP/IP Access Rights
SSL
Utilities
Viewing file contents
Database Registration Manager
Using Navigation bar and Toolbar
Database Objects Management
New Object
Duplicate Object Wizard
Selecting the source database
Selecting object to duplicate
Selecting destination database
Modifying the new object's definition
Schema objects
Tables
New table
Using Navigation bar and Toolbar
Setting table properties
Specifying fields
Specifying foreign keys
Setting physical attributes
Setting overflow attributes
Partitioning
Table Editor
Using Navigation bar and Toolbar
Managing fields
Managing keys
Managing foreign keys
Managing checks
Managing indexes
Managing triggers
Working with table data
Table Properties
Regular
Global Temporary
Clustered
Index-organized
External
Record parameters
Field parameters
Fields
Field Editor
Setting field name and type
Setting default value and comment
Keys
Key Editor
Creating/editing key
Storage options
Setting key options
Foreign Keys
Foreign Key Editor
Creating/editing foreign key
Setting foreign key options
Checks
Check Editor
Creating/editing check
Setting check options
Views
View Editor
Using Navigation bar and Toolbar
Creating/editing view
Managing fields
Managing keys
Managing foreign keys
Managing triggers
Working with data
Procedures
Procedure Editor
Using Navigation bar and Toolbar
Creating/editing procedure
Browsing procedure parameters
Specifying input parameters
Executing procedure/function
Functions
Function Editor
Using Navigation bar and Toolbar
Creating/editing function
Browsing function parameters
Triggers
Trigger Editor
Using Navigation bar and Toolbar
Creating/editing trigger
DB and Schema Triggers
DB/Schema Trigger Editor
Using Navigation bar and Toolbar
Creating/editing DB/schema trigger
Indexes
Index Editor
Using Navigation bar and Toolbar
Creating/editing index
Packages
Package Editor
Using Navigation bar and Toolbar
Creating/editing package
Package Bodies
Package Body Editor
Using Navigation bar and Toolbar
Creating/editing package body
Sequences
Sequence Editor
Using Navigation bar and Toolbar
Creating/editing sequence
Clusters
Cluster Editor
Using Navigation bar and Toolbar
Creating/editing cluster
Materialized Views
Materialized View Editor
Using Navigation bar and Toolbar
Creating/editing materialized view
Managing fields
Setting Refresh parameters
Setting USING INDEX parameters
Working with data
Partitioning
Materialized View Logs
Materialized View Log Editor
Using Navigation bar and Toolbar
Creating/editing materialized view log
Synonyms
Synonym Editor
Using Navigation bar and Toolbar
Creating/editing synonym
Database Links
Database Link Editor
Using Navigation bar and Toolbar
Creating/editing database link
Object Types
Object Type Editor
Using Navigation bar and Toolbar
Creating/editing object type
Object Type Bodies
Object Type Body Editor
Using Navigation bar and Toolbar
Creating/editing object type body
Array Types
Array Type Editor
Using Navigation bar and Toolbar
Creating/editing array type
Libraries
Library Editor
Using Navigation bar and Toolbar
Creating/editing library
Java Sources
Java Source Editor
Using Navigation bar and Toolbar
Creating/editing Java source
Java Classes
Java Class Editor
Using Navigation bar and Toolbar
Creating/editing Java class
Java Resources
Java Resource Editor
Using Navigation bar and Toolbar
Creating/editing Java resource
Index Types
Index Type Editor
Using Navigation bar and Toolbar
Creating/editing index type
Operators
Operator Editor
Using Navigation bar and Toolbar
Creating/editing operator
Adding operator binding
Dimensions
Dimension Editor
Using Navigation bar and Toolbar
Creating/editing dimension
Adding dimension level
Adding dimension hierarchy
Queue
Queue Editor
Using Navigation bar and Toolbar
Creating/editing queue
Adding Subscribers
Schedules
Queue Table
Queue Table Editor
Using Navigation bar and Toolbar
Creating/editing queue table
Defining Physical Attributes
Statistics
Non-schema objects
Contexts
Context Editor
Using Navigation bar and Toolbar
Creating/editing context
Profiles
Profile Editor
Using Navigation bar and Toolbar
Creating/editing profile
Consumer Groups
Consumer Group Editor
Using Navigation bar and Toolbar
Creating/editing consumer group
Resource Plans
Resource Plan Editor
Using Navigation bar and Toolbar
Creating/editing resource plan
Directives Options
Directive Comments
Directories
Directory Editor
Using Navigation bar and Toolbar
Creating/editing directory
Tablespaces
Tablespace Editor
Using Navigation bar and Toolbar
Creating/editing tablespace
Managing files
Managing objects
Rollback Segments
Rollback Segment Editor
Using Navigation bar and Toolbar
Creating/editing rollback segment
Redo Log Groups
Redo Log Group Editor
Using Navigation bar and Toolbar
Creating/editing redo log group
Scheduler Schedules
Scheduler Schedule Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler schedule
Scheduler Programs
Scheduler Program Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler program
Scheduler Chains
Scheduler Chain Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler chain
Scheduler Job Classes
Scheduler Job Class Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler job class
Scheduler Jobs
Scheduler Job Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler job
Scheduler Window Groups
Scheduler Window Group Editor
Using Navigation bar and Toolbar
Creating/Editing scheduler window group
Scheduler Windows
Scheduler Window Editor
Using Navigation bar and Toolbar
Creating/Editing window
Users and Roles
Users
User Editor
Using Navigation bar and Toolbar
Creating/editing user
Tablespace parameters
Setting quotas
Proxy Users
Roles
Role Editor
Using Navigation bar and Toolbar
Creating/editing role
Query Management Tools
SQL Editor
Using Navigation bar and Toolbar
Working with SQL Editor area
Using the context menu
Viewing query plan
Using object links
Executing queries
Viewing query logs
Using PL/SQL Code Debugger
Favorites editor
Merging queries
Visual Query Builder
Using Navigation bar and Toolbar
Working with diagram area
Joining two objects
Setting criteria
Setting output fields
Setting grouping criteria
Setting sorting parameters
Working with the editor area
Query execution
Viewing query plan
Query parameters
Input parameters dialog
Data Management
Data View
Using Navigation bar and Toolbars
Grid View
Customizing columns
Grouping data
Filtering records
Using the context menu
Working in multi-level mode
Create Grid Level wizard
Specifying master level
Defining source for detail level
Binding master and detail levels
Query parameterization
Setting additional parameters
Working in card view mode
Column Summary
Copying records
Form View
Print Data
Page Setup
Page
Margins
Header/Footer
Scaling
Report Formatter
View
Behaviors
Formatting
Styles
Preview
Cards
Charts
Setting report options
Print dialog
BLOB View
Navigation within BLOB Editor
Editing as Hexadecimal
Editing as Text
Editing as Rich Text
Editing as Image
Editing as HTML
Editing as XML
Applying changes
Custom Filter
Filter Builder dialog
Invoking the Filter Builder dialog
Adding a new condition
Setting filter criteria
Setting filter operator
Setting filter criteria values
Adding a new group
Setting group operator
Applying filter conditions
Import/Export Tools
Export Data Wizard
Setting destination file name and format
Selecting fields for export
Adjusting data formats
Setting header and footer
Setting format-specific options
Excel options
Data format
Fields
Options
Styles
Extensions
Hyperlinks
Notes
Charts
Cells
Merged Cells
Advanced
Access options
Word / RTF options
Base Styles
Strip Styles
HTML options
Preview
Basic
Multi-file
Advanced
PDF options
TXT options
CSV options
XML options
MS Excel 2007 / ODS options
MS Word 2007 / ODT options
Setting common export options
Exporting data
Import Data Wizard
Selecting source file name and format
Selecting data source
Setting fields correspondence
Excel
Access
DBF
XML Datapacket
TXT
CSV
HTML
XML Generic
MS Excel/Word 2007, ODF
Adjusting data formats
Setting advanced field formats
Setting import mode
Customizing common options
Importing data
Export as SQL Script
Selecting destination DBMS
Setting destination file name
Setting BLOB options
Selecting fields to export
Editing table definition
Setting export options
Exporting as SQL Script
Database Tools
Common DB Tools
Dependency Tree
Using Navigation bar and Toolbar
Viewing dependency tree
Visual Database Designer
Using Navigation bar and Toolbars
Using Diagram Navigator and DB Objects pane
Using context menus
Working with diagram objects
Adding/removing objects to/from diagram
Incremental search
Creating objects
Creating relations
Working with diagram pages
Reverse engineering
Printing diagram
Print Preview
Print Setup dialog
Saving/loading diagram
Setting diagram options
SQL Script Editor
Using Navigation bar and Toolbar
Working with SQL Script editor area
Using Script Explorer
Script execution
Extract Database Wizard
Selecting source database
Specifying destination file name
Setting extraction mode
Setting BLOB options
Selecting objects for structure extraction
Selecting objects for data extraction
Customizing script options
Start of extraction process
Print Metadata
Using Navigation bar and Toolbar
Selecting objects
Printing options
HTML Report Wizard
Selecting database and directory
Selecting object types
Selecting schemas
Specifying CSS
Setting additional report options
Creating HTML report
Reports management
Create Report Wizard
Specifying database name and report options
Selecting report bands
Selecting report style
Specifying page settings
Specifying paper settings
Specifying margins
Specifying other page settings
Report Designer
Adding dialog form
Adding database and query components
Adding report data
Saving the report
Report Editor
Using Navigation bar and Toolbar
Viewing Report
Report Viewer
Using Toolbar and context menu
Working with Report Viewer
Page settings
Exporting report content
Sending by E-mail
SQL Monitor
Using Navigation bar and Toolbar
Working with SQL Monitor
Search in Metadata
Specific DB Tools
PL/SQL Profiler
Using Navigation bar and Toolbar
Using PL/SQL Profiler
Advanced Statistics Wizard
Selecting database and stats mode
Selecting objects
Specifying additional settings
Managing statistics
TKProf Wizard
Defining common settings
Selecting input files
Setting sorting options
Defining execution plan
Specifying additional options
Backup Database
Selecting database and backup strategy
Checking database and instance settings
User-managed script
Selecting datafiles
Setting additional options
Recovery Manager (RMAN)
Specifying backup type and options
Setting additional options
Scheduling backup scripts
Running database backup operation
Restore Database
Selecting database and restore strategy
User-managed script
Verifying current settings
Selecting datafiles
Setting additional options
Recovery Manager (RMAN)
Setting additional options
Running database restore operation
Flashback
Specifying the source database and selecting the operation
Selecting the table to flashback
Specifying flashback settings
Previewing the data in the selected flashback point
Running flashback operation
Truncate Wizard
Selecting database and object type
Selecting objects
Setting truncate options
Recompile Invalid Objects
Using Navigation bar and Toolbar
Working with recompile service
Enable/Disable constraints
Selecting database
Selecting schema and tables
Specifying operation and target
Instance Manager
Using Navigation and Toolbar Bar
Job Manager
Using Navigation bar and Toolbar
Managing jobs
Job Editor
Grant Manager
Using Navigation bar, Toolbar and context menu
Setting object grants
Managing database-specific privileges
Managing column permissions
Filtering objects in list
Managing system privileges
Managing roles
Compare Databases Wizard
Selecting source database
Selecting schemas of the source database
Selecting target database
Selecting schemas of the target database
Selecting type of the synchronization script
Defining options for destination script
Performing operation
Server/Instance Tools
Oracle Client Checker
Database Information
Common Parameters
Instance Parameters
Extended Parameters
Database Statistics
Using Navigation bar and Toolbar
System Statistics
Last Analyze Stats
Sessions
Hit Ratios
Process
Locks
Storage
Tablespace
Control Files
Data Files
RBS Activity
SGA
Summary SGA
Library Cache
Data Dictionary Cache
Wait Events
Latches
Database Alerts
Personalization
SQL Manager Options
Environment Options
Preferences
Full mode activation
Confirmations
Windows
Tools
DB Explorer
Object Editors
SQL Editor
SQL Monitor
Database Alerts Settings
SQL Script
Query Builder
Style & Color Palette
Visual Database Designer
Print Metadata
Data Export
Fonts
Grid
Data Options
Print Data
Color & Formats
Advanced
Column Options
Localization
Global Shortcuts
Find Option
Editor Options
General
Display
Highlight
Quick Code
SQL Formatter
SQL Words
Key Mapping
Spell Checking
Find Option
Visual Options
Bars and menus
Trees and lists
Edit controls
Check boxes
Buttons
Page controls
Group boxes
Splitters
Navigation bar
Find Option
Save Settings
Specifying destination file
Selecting settings
Selecting databases
Saving settings
Localization
Localization Editor
Select Program Language
Keyboard Templates
Object Templates
Find Option dialog
External Tools
External Tools dialog
External Tool Info Editor
How to...
Group objects
Find objects
Enable login prompt for a database
Make work with a database faster
Create a database copy
Document a database
Log database changes
Design a visual database structure
Synchronize two databases
View an ER diagram
Get an SQL dump
View dependecies
View tables with many records
Export/import data
Export filtered data
Sort and group data
Edit data of master-detail tables
Create an autoincrement field
Add image to table
Set data display format
Debug procedures
Save most frequently used queries
Execute a large SQL script
Make SQL script work faster
Execute queries with parameters
Customize work with Query/Script text
View executed queries and scripts
Get an object DDL
Create SQL statements rapidly
Transfer program settings
Create a simple report in Report Designer
Update SQL Manager
Report bugs and suggestions
Appendix
Advanced connection settings
Program interface
Viewing object DDL structure
Editing object description
Browsing object dependencies
Setting object permissions
Adding restore point
Changing Metadata window
Tip of the Day
Find Text dialog
Replace Text dialog
Format specifiers
Language Info Editor
Using templates
Supported file formats
To-Do List
Window List
Customize toolbars and menus
SSH tunneling options
SQL Manager Direct
Database Login dialog
Overwriting existing output file
Script conversion
Storage attributes
Select Object dialog
SQL Manager shortcuts