Oracle SQL Developer User’s Guide Oracle® User's
User Manual:
Open the PDF directly: View PDF
Page Count: 194 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- List of Figures
- Preface
- 1 SQL Developer Concepts and Usage
- 1.1 Installing and Getting Started with SQL Developer
- 1.2 SQL Developer User Interface
- 1.3 Database Objects
- 1.3.1 Applications (Application Express 3.0.1 and Later)
- 1.3.2 Cache Groups (Oracle TimesTen In-Memory Database)
- 1.3.3 Database Links (Public and Private)
- 1.3.4 Directories
- 1.3.5 Functions
- 1.3.6 Indexes
- 1.3.7 Java Sources
- 1.3.8 Materialized Views
- 1.3.9 Materialized View Logs
- 1.3.10 Packages
- 1.3.11 Procedures
- 1.3.12 Queues
- 1.3.13 Queue Tables
- 1.3.14 Recycle Bin
- 1.3.15 Replication Schemes (Oracle TimesTen In-Memory Database)
- 1.3.16 Sequences
- 1.3.17 Synonyms (Public and Private)
- 1.3.18 Tables
- 1.3.19 Triggers
- 1.3.20 Types
- 1.3.21 Users (Other Users)
- 1.3.22 Views
- 1.3.23 XML Schemas
- 1.3.24 Captured and Converted Database Objects (for Migration)
- 1.4 Database Connections
- 1.5 Entering and Modifying Data
- 1.6 Running and Debugging Functions and Procedures
- 1.7 Using the SQL Worksheet
- 1.8 Using Snippets to Insert Code Fragments
- 1.9 Using Find DB Object to Find Database Objects
- 1.10 Using Extended Search
- 1.11 Using Versioning
- 1.12 SQL Developer Reports
- 1.12.1 About Your Database reports
- 1.12.2 All Objects reports
- 1.12.3 Application Express reports
- 1.12.4 ASH and AWR reports
- 1.12.5 Charts reports
- 1.12.6 Database Administration reports
- 1.12.7 Data Dictionary reports
- 1.12.8 Jobs reports
- 1.12.9 PL/SQL reports
- 1.12.10 Security reports
- 1.12.11 Streams reports
- 1.12.12 Table reports
- 1.12.13 XML reports
- 1.12.14 Migration reports
- 1.12.15 User Defined reports
- 1.13 SQL Developer Preferences
- 1.14 Location of User-Related Information
- 1.15 Oracle TimesTen In-Memory Database Support
- 1.16 Using the Help
- 1.17 For More Information
- 2 Migrating Third-Party Databases
- 2.1 Migration Quick Start
- 2.2 Overview of Migration
- 2.3 Preparing a Migration Plan
- 2.4 Before You Start Migrating: General Information
- 2.5 Before You Start Migrating: Source-Specific Information
- 2.6 Capturing the Source Database
- 2.7 Creating and Customizing the Converted Model
- 2.8 Generating the DDL for the Oracle Schema Objects
- 2.9 Migrating the Data
- 2.10 Making Queries Case Insensitive
- 2.11 Testing the Oracle Database
- 2.12 Deploying the Oracle Database
- 2.13 Using Migration Reports
- 2.14 SQL Developer User Interface for Migration
- 3 Tutorial: Creating Objects for a Small Database
- 3.1 Create a Table (BOOKS)
- 3.2 Create a Table (PATRONS)
- 3.3 Create a Table (TRANSACTIONS)
- 3.4 Create a Sequence
- 3.5 Insert Data into the Tables
- 3.6 Create a View
- 3.7 Create a PL/SQL Procedure
- 3.8 Debug a PL/SQL Procedure
- 3.9 Use the SQL Worksheet for Queries
- 3.10 Script for Creating and Using the Library Tutorial Objects
- 4 Dialog Boxes for Creating/Editing Objects
- 4.1 Add Extension
- 4.2 Branch/Tag
- 4.3 Check for Updates
- 4.4 Check Out from CVS
- 4.5 Check Out from Subversion
- 4.6 Choose Directory
- 4.7 Confirm Drop Application
- 4.8 Confirm Running SQL
- 4.9 Connection Has Uncommitted Changes
- 4.10 Create/Edit New Object (New Gallery)
- 4.11 Create/Edit CVS Connection
- 4.12 Create/Edit/Select Database Connection
- 4.13 Rename Model (Migration)
- 4.14 Rename Database Item (Migration)
- 4.15 Select Connection
- 4.16 Connection Information
- 4.17 No Connection Found
- 4.18 Connection Rename Error
- 4.19 New Folder (Connections)
- 4.20 Continue After Pause
- 4.21 Select Library
- 4.22 Create Library
- 4.23 Import Data
- 4.24 Export/Import Connection Descriptors
- 4.25 Create/Edit Database Link
- 4.26 Create/Edit Index
- 4.27 Create Filter
- 4.28 Create/Edit Materialized View Log
- 4.29 Create PL/SQL Package
- 4.30 Create PL/SQL Subprogram (Function or Procedure)
- 4.31 Create Remote Directory
- 4.32 Create/Edit Sequence
- 4.33 Create SQL File
- 4.34 Create/Edit Subversion Connection
- 4.35 Create Subversion Repository
- 4.36 Create/Edit Synonym
- 4.37 Create Table (quick creation)
- 4.38 Create/Edit Table (with advanced options)
- 4.39 Storage Options
- 4.40 Create Trigger
- 4.41 Create Type (User-Defined)
- 4.42 Create/Edit User
- 4.43 Create/Edit User Defined Report
- 4.44 Create/Edit User Defined Report Folder
- 4.45 Create/Edit View
- 4.46 Create XML Schema
- 4.47 Configure Extension
- 4.48 Configure File Type Associations
- 4.49 Custom Filters
- 4.50 Database Copy (Schema Objects)
- 4.51 Database Schema Differences
- 4.52 DDL Panel for Creating or Editing an Object
- 4.53 Debugger - Attach to JPDA
- 4.54 Deploy or Import Application
- 4.55 Describe Object Window
- 4.56 Edit Value (Table Column Data)
- 4.57 Enter Bind Values
- 4.58 Error Writing to Export File
- 4.59 Export (Database Objects and Data)
- 4.60 Export: Advanced Data Filter
- 4.61 Export Error
- 4.62 Export Table Data
- 4.63 External Locator Configuration
- 4.64 External Tools
- 4.65 Create/Edit External Tool
- 4.66 Choose Offline Options
- 4.67 Feature Required
- 4.68 Filter
- 4.69 Insert Macro
- 4.70 Externally Modified Files
- 4.71 Filter Object Types
- 4.72 Filter Schemas
- 4.73 Filter Error
- 4.74 Find/Replace Text
- 4.75 Find Result
- 4.76 Generate Oracle DDL
- 4.77 Generate Offline Data Move Files
- 4.78 Go to Bookmark
- 4.79 Go to Line Number
- 4.80 Go to Line Number: Error
- 4.81 Import to CVS
- 4.82 Load Preset Key Mappings
- 4.83 Log In to CVS
- 4.84 Modify Value
- 4.85 Data Move Details
- 4.86 New Procedure (Refactoring)
- 4.87 No Object Found
- 4.88 No Object Selected
- 4.89 Open File
- 4.90 Oracle-Only Report
- 4.91 Oracle Proxy Authentication
- 4.92 Paste
- 4.93 Privilege Warning for Migration
- 4.94 Query Builder
- 4.95 Recent Files
- 4.96 Create Repository
- 4.97 Delete or Truncate Repository
- 4.98 Capture Microsoft Access Exporter XML
- 4.99 Rename Local Variable
- 4.100 Rename Procedure
- 4.101 Select Current Repository
- 4.102 Cannot Capture Table
- 4.103 Reset Expired Password
- 4.104 Revision Lister
- 4.105 Run/Debug/Profile PL/SQL
- 4.106 Create/Edit Breakpoint
- 4.107 Save/Save As
- 4.108 Save Files
- 4.109 Unable to Save Files
- 4.110 Save Style Settings
- 4.111 Schema Differences Source or Destination Error
- 4.112 Script Execution Failed
- 4.113 Script Generation Complete
- 4.114 Set Data Mapping
- 4.115 Add/Edit Rule
- 4.116 Set Encoding
- 4.117 Set Pause Continue
- 4.118 Sign In (checking for updates)
- 4.119 Single Record View
- 4.120 Save Snippet (User-Defined)
- 4.121 Edit Snippets (User-Defined)
- 4.122 Unable to Open File
- 4.123 Unsupported Database Version
- 4.124 Windows
- Index