User's Guide Oracle SQL Developer
Oracle SQL DeveloperUser's GuideRelease 18.2E97013-01July 2018
Oracle SQL Developer User's Guide, Release 18.2E97013-01Copyright 2006, 2018, Oracle and/or its affiliates. All rights reserved.Primary Author: Celin CherianContributing Authors: Chuck MurrayThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify,license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means.Reverse engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agencyspecific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of theprograms, including any operating system, integrated software, any programs installed on the hardware,and/or documentation, shall be subject to license terms and license restrictions applicable to the programs.No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPrefaceAudiencexxviDocumentation AccessibilityxxviProduct AccessibilityxxviRelated DocumentsxxviConventionsxxviiThird-Party License InformationxxviiChanges in This Release for Oracle SQL Developer User’s Guide1Changes in Oracle SQL Developer Release 18.2xlviiiChanges in Oracle SQL Developer Release 18.1xlviiiSQL Developer Concepts and Usage1.1About SQL Developer1-21.2Installing and Getting Started with SQL Developer1-21.3SQL Developer User Interface1-31.41.3.1Menus for SQL Developer1.3.2Restoring the Original "Look and Feel"Database Objects1-71-121-131.4.1Applications (Application Express 3.0.1 and Later)1-131.4.2Cache Groups (Oracle TimesTen In-Memory 4.5Database Destinations1-151.4.6Database Links (Public and Private)1-151.4.7Destination .10File i
1.4.13Java Sources1-181.4.14Jobs1-181.4.15Job Classes1-181.4.16Operators1-181.4.17Materialized Views1-191.4.18Materialized View Logs1-191.4.19Multitenant Container Database .22Programs1-211.4.23Queues1-211.4.24Queue Tables1-211.4.25Recycle Bin1-211.4.26Replication Schemes (Oracle TimesTen In-Memory 21.4.29Synonyms (Public and Private)1-221.4.30Tables1-221.4.30.11.5Flashback Table Users (Other Users)1-251.4.34Views1-261.4.35Window Groups1-261.4.36Windows1-271.4.37XML DB Repository1-271.4.38XML Schemas1-271.4.39Captured and Converted Database Objects (for Migration)1-27Database Connections1-281.5.1Using Folders to Group Connections1-301.5.2Sharing of Connections1-311.5.3Advanced Security for JDBC Connection to the Database1-311.5.4Connections with Operating System (OS) Authentication1-311.5.5Connections with Proxy Authentication1-321.5.6Connections with SSH Authentication1-331.6Entering and Modifying Data1-341.7Running and Debugging Functions and Procedures1-361.7.1Using Bookmarks When Editing Functions and Procedures1-381.7.2Remote Debugging1-381.7.3Displaying SQL Trace (.trc) Files1-391.7.4Using the PL/SQL Hierarchical Profiler1-39iv
1.7.5Setting Expression Watches1-401.7.6Semantic Analysis1-401.7.6.11.8SQL Injection DetectionUsing the SQL Worksheet1-411-421.8.1SQL*Plus Statements Supported in SQL Worksheet1-451.8.2Script Runner1-461.8.3Execution Plan1-461.8.4Autotrace Pane1-471.8.5DBMS Output Pane1-471.8.6OWA Output Pane1-471.8.7SQL History1-481.8.8Query Builder1-481.8.9Command-Line Interface for SQL Formatting1-491.8.10SQL Worksheet "Hints" for Formatting Output1-491.8.11Gauges: In the SQL Worksheet and User-Defined Reports1-501.8.12Entering OLAP DML Statements in the SQL Worksheet1-511.9Using Snippets to Insert Code Fragments1.9.1User-Defined Snippets1-511-521.10Finding Database Objects1-521.11Using Recent Objects1-541.12Using Versioning1-541.12.1About Subversion and SQL Developer1-541.12.2Pending Changes1-551.13Using DBA Features in SQL Developer1-551.13.1Container Database (CDB)1-581.13.2Database Configuration1-581.13.2.1Initialization Parameters1-581.13.2.2Automatic Undo Management1-581.13.2.3Current Database Properties1-591.13.2.4Restore Points1-591.13.2.5View Database Feature Usage1-591.13.3Database Status1-591.13.3.1Status1-591.13.3.2DB Instance1-591.13.3.3Instance Viewer1-591.13.4Data Guard1-601.13.5Data Pump1-601.13.5.1Export Jobs1-601.13.5.2Import Jobs1-601.13.6Oracle Sharding1-611.13.7Performance1-62v
Baseline Templates1-631.13.7.4Automatic Database Diagnostic Monitor (ADDM)1-631.13.7.5ASH (Active Session History) Report Viewer1-631.13.7.6AWR (Automatic Workload Repository)1-631.13.8RMAN Backup/Recovery1-641.13.8.1Backup Jobs1-641.13.8.2Backup Sets1-641.13.8.3Image Copies1-641.13.8.4RMAN Settings1-641.13.8.5Scheduled RMAN Actions1-641.13.8.6Using Action Jobs1-641.13.9Resource Manager1-651.13.9.1Consumer Group Mappings1-651.13.9.2Consumer 3.9.5Statistics1-661.13.10SQL Translator FrameWork1-661.13.10.1SQL Translator Profiles1-661.13.10.2SQL Translators1-661.13.11Scheduler1-661.13.11.1Global Attributes1-661.13.11.2Job Classes1-661.13.11.3External Destinations1-671.13.12Security1-671.13.12.1Audit ive Logs1-671.13.13.2Control Files1-671.13.13.3Datafiles1-681.13.13.4Redo Log Groups1-681.13.13.5Rollback rary Tablespace Groups1-681.13.14Tuning1.13.14.1Real Time SQL Monitor1-681-68vi
1.14Scheduling Jobs Using SQL Developer1.14.11.15Scheduler Design EditorUsing the Cart1-691-701-701.15.1Adding Data Files to the Cart1-731.15.2Cart Versus Database Export Wizard1-741.16Spatial Support in SQL Developer1-741.16.1Context Menu Operations on Spatial Data and Metadata1-751.16.2Map Visualization of Spatial Data1-751.171.16.2.1Visualizing Geometries by Creating and Executing a Query1-761.16.2.2Visualizing Geometries from the Table Data Grid1-77Change Manager Support in SQL Developer1-771.17.1Change Plan Administrators and Developers1-781.17.2Developing Change Plans with SQL Developer1-781.17.2.1Creating a Repository Connection1-801.17.2.2Creating and Deleting Change Plans1-801.17.2.3Adding and Updating Change Items1-801.17.2.4Using Change Plans to Capture Change in SQL Developer1-801.17.3Change Manager Actions to Perform with Enterprise Manager1.17.3.11.17.3.21.181-81Creating Change Plans from Change Manager SchemaComparisons1-81Deploying Change Plans1-81Apache Hadoop Connectors Support in SQL Developer1-821.18.1Copy to Hadoop: Overview and Requirements1-831.18.2Oracle Loader for Hadoop: Overview and Requirements1-841.18.3Oracle SQL Connector for HDFS: Overview and Requirements1-851.19SQL Developer Reports1-851.19.1Bind Variables for Reports1-871.19.2About Your Database reports1-871.19.3All Objects reports1-871.19.4Application Express reports1-881.19.5ASH and AWR reports1-881.19.6Charts reports1-881.19.7Database Administration reports1-881.19.8Data Dictionary reports1-891.19.9Scheduler reports1-891.19.10PL/SQL reports1-891.19.11Security reports1-891.19.12Streams reports1-901.19.13Table reports1-901.19.13.11.19.14Quality Assurance reportsXML reports1-921-92vii
1.19.15Data Modeler reports1-921.19.16User Defined reports1-931.201.19.16.1User-Defined Report Example: Chart1-931.19.16.2User-Defined Report Example: Dynamic HTML1-95SQL Developer Preferences1-951.20.1Environment1-951.20.2Change Management Parameters1-961.20.3Code Editor1-981.20.4Compare and 20.7External Editor1-1141.20.8File Types1-1151.20.9Global Ignore List1-1151.20.10Migration1-1151.20.11Mouse Actions1-1191.20.12Shortcut Keys (Accelerator Keys)1-1201.20.13SSH (Secure Shell)1-1201.20.14Unit Test Parameters1-1201.20.15Usage oning: Git1-1211.20.16.2Versioning: Subversion1-1221.20.16.3Versioning: CVS1-1231.20.16.4Versioning: Perforce1-1251.20.17Web Browser and Proxy1-1261.20.18XML Schemas1-1271.21Location of User-Related Information1-1271.22Java Development Kit (JDK) Location1-1281.23Command-Line Interface for SQL Developer1-1281.24Data Modeler in SQL Developer1-1291.25Oracle TimesTen In-Memory Database Support1-1301.26Using the Help1-1301.27SQL Developer Usage Suggestions1-1311.27.1SQL History Shortcuts1-1311.27.2Unshared Worksheets1-1311.27.3SQL Worksheet Bookmarks1-1311.27.4Oracle Data Miner1-1311.27.5Formatted Display of SQL Trace (.trc) Files1-1311.27.6Keyboard Navigation: Alt Page Down/Up to Move Among Tabs1-1311.27.7Folders for Organizing Connections1-131viii
1.27.8Third-Party Databases and SQL Developer1-1321.27.9Debugger Ports and Firewalls1-1321.27.10Viewing Multiple Tables1-1321.27.11Customizing SQL Developer Appearance1-1321.27.12Maximizing Tab Panes1-1321.27.13Default Path for Running Scripts1-1321.27.14Shutting Down and Restarting the Database1-1321.27.15Feature Requests1-1321.27.16Discussion Forums1-1331.27.17Help Text Font Size1-1331.27.18Procedure and Function Signatures1-1331.27.19Type-Ahead in Navigators1-1331.27.20Extended Paste1-1331.27.21Closing Tabbed Windows Using the Mouse Wheel1-1331.27.22Go to Last Edit Location1-1331.27.23Closing Tabbed Windows Using the Context Menu1-1341.27.24List of All Open Windows1-1341.27.25Go to Subprogram Implementation from Package Window1-1341.27.26Select Multiple Table or Column Names in Completion Insight1-1341.27.27Startup Time and Automatic Check for Updates1-1341.282For More Information About SQL Developer1-134SQL Developer: Migrating Third-Party Databases2.1Migration: Basic Options and 2.1.1.3Source .6Translate2-42.1.1.7Target Database2-42.1.1.8Move Data2-42.1.1.9Summary2-52.1.22.2Migrating Using the Migration Wizard2-1Copying Selected Tables to OracleMigration: Background Information and Guidelines2.2.1Overview of Migration2.2.1.12.2.2Migration Implemented as SQL Developer ExtensionsPreparing a Migration Plan2.2.2.1Task 1: Determining the Requirements of the Migration Project2-52-62-72-72-72-8ix
2.2.2.2Task 2: Estimating Workload2.2.2.3Task 3: Analyzing Operational Requirements2-102.2.2.4Task 4: Analyzing the Application2-112.2.2.5Task 5: Planning the Migration Project2-122.2.3Before You Start Migrating: General InformationCreating a Database User for the Migration Repository2-132.2.3.2Requirements for Creating the Destination Oracle Objects2-13Before You Start Migrating: Source-Specific InformationBefore Migrating From IBM DB22-152.2.4.2Before Migrating From Microsoft SQL Server or Sybase AdaptiveServer2-152.2.4.3Before Migrating From MySQL2-162.2.4.4Before Migrating From Teradata2-17Capturing the Source Database2.2.5.12.2.6Offline CaptureCreating and Customizing the Converted Model2.2.6.1Correcting Errors in the Converted Model2-172-182-192-192.2.7Generating the DDL for the Oracle Schema Objects2-202.2.8Migrating the Data2-202.2.8.12.2.92.2.10Transferring the Data OfflineMaking Queries Case InsensitiveTesting the Oracle Database2-202-252-252.2.10.1Testing Methodology2-262.2.10.2Testing the Oracle .2.42.32-9Deploying the Oracle Database2-302.2.11.1Choosing a Rollout Strategy2-302.2.11.2Deploying the Destination Database2-31SQL Developer User Interface for Migration2-322.3.1Migration Submenu2-342.3.2Other Menus: Migration Items2-342.3.3Migration Preferences2-342.3.4Migration Log Panes2-342.3.5Using the Translation Scratch Editor2-35Command-Line Interface for Migration2-36SQL Developer: Oracle REST Data Services Support3.1Installing Oracle REST Data Services3-13.2Oracle REST Data Services Administration3-13.2.1About Oracle REST Data Services3-23.2.2Oracle REST Data Services Administration Toolbar and Context Menu3-23.2.3Connecting to Oracle REST Data Services3-3x
3.2.43-43.2.4.1Connections3-53.2.4.2Default Password3-73.2.4.3ORDS Public User (Database Settings Only)3-73.2.4.4PL/SQL Gateway User (Database Settings Only)3-73.2.4.5APEX REST Users (Database Settings Only)3-73.2.4.6Security3-73.2.4.7Cache REST Data Services Navigator: NoSQL Store Configuration3-113.2.6REST Data Services Navigator: Reports3-113.33.44REST Data Services Navigator: Global Settings and Database SettingsAutomatically Enabling REST Access to a Schema, Table, or View(AutoREST)3-12REST Development3-133.4.1About RESTful Services3-133.4.2RESTful Services Terminology3-133.4.3RESTful Services Requirements and Setup3-143.4.4REST Data Services in the Connections Navigator3-143.4.5REST Development Pane3-15SQL Developer: Unit Testing4.1Overview of Unit Testing4-14.2SQL Developer User Interface for Unit Testing4-24.2.1Unit Test Submenu4-34.2.2Other Menus: Unit Test Items4-44.2.3Unit Test Preferences4-44.3Unit Test Repository4.3.1Managing Repository Users and Administrators4-44-54.4Editing and Running a Unit Test4-54.5Using a Dynamic Value Query to Create a Unit Test4-64.6Using Lookups to Simplify Unit Test Creation4-84.6.1Providing Values for Input Fields4-84.6.2Automatically Creating Implementations4-94.7Using Variable Substitution in Validation Actions4-104.8Unit Test Library4-114.9Unit Test Reports4-114.10Exporting and Importing Unit Test Objects4-124.11Command-Line Interface for Unit Testing4-124.12Unit Testing Best Practices4-134.12.1Strategy4-14xi
4.12.2Test Suites4-144.12.3Test Naming4-144.12.4Avoiding Test Naming Clashes4-144.12.5Test -154.12.8Test and Suite e the EMPLOYEES Table4-174.13.2Create the AWARD BONUS Procedure4-174.13.3Create the Unit Testing Repository4-184.13.4Create a Unit Test4-184.13.5Run the Unit Test4-204.13.6Create and Run an Exception Unit Test4-204.13.7Create a Unit Test Suite4-214.13.8Run the Unit Test Suite4-22SQL Developer Tutorial: Creating Objects for a Small Database5.1Create a Table (BOOKS)5-25.2Create a Table (PATRONS)5-35.3Create a Table (TRANSACTIONS)5-55.4Create a Sequence5-65.5Insert Data into the Tables5-75.6Create a View5-85.7Create a PL/SQL Procedure5-95.8Debug a PL/SQL Procedure5-105.9Use the SQL Worksheet for Queries5-125.106Example of Unit Testing (Tutorial)Script for Creating and Using the Library Tutorial Objects5-13SQL Developer Dialog Boxes and Wizards6.1Add Extension6-16.2Add Schema Error6-26.3Advanced Properties (Connections)6-26.3.1Proxy tab6-26.4Application Migration6-26.5Associate Repository6-36.6Cart Error (Objects Not Available)6-36.7Change Type6-3xii
6.8Check for Updates6-46.9Choose Configuration File Option6-46.10Choose Directory6-56.11Clone PDB to Oracle Cloud6-56.12Clone Pluggable Database6-66.13Cloud Migrations Wizard6-66.13.1AWS Redshift Database6-76.13.2Autonomous Data Warehouse Cloud6-76.13.3Summary6-86.14Color Palette and Custom Colors6-86.15Configure Extension6-86.16Configure File Type Associations6-86.17Configure OSS6-96.18Copy Columns6-96.19Copy Objects6-96.20Copy to Hadoop / Append to Hadoop Table6-106.21Copy to Oracle6-116.22Component Palette6-126.23Component Palette: Configure Component Palette6-126.24Component Palette: Create Palette Page6-126.25Component Palette: New/Edit Code Snippet6-126.26Component Palette: New Section/Rename Section6-136.27Confirm Drop Application6-136.28Confirm Running SQL6-136.29Connection Has Uncommitted Changes6-136.30Create New Object6-136.31Create/Edit Chain6-146.32Create/Edit Credential6-146.33Create/Edit/Select Database Connection6-156.33.1Oracle tab6-166.33.2TimesTen tab6-186.33.3Amazon Redshift tab6-186.33.4DB2 tab6-196.33.5Hive tab6-196.33.6JDBC tab6-206.33.7MySQL tab6-206.33.8PostgreSQL tab6-206.33.9SQL Server and Sybase tab6-216.33.10Teradata tab6-216.33.11Creating and Editing Connections6-226.34New/Edit Cloud Connection6-22xiii
6.34.1Advanced Connection Information6-236.35New/Edit NoSQL Connection6-236.36Rename Model (Migration)6-246.37Delete Confirmation6-246.38Delete Confirmation (Migration)6-246.39Rename Database Item (Migration)6-246.40Select Connection6-246.41Connection Information6-256.42No Connection Found6-256.43Connection Rename Error6-256.44New Folder (Connections)6-256.45Continue After Pause6-256.46Select Library6-266.47Create Library6-266.48CVS: Check Out from CVS6-266.49CVS: Create/Edit CVS Connection6-266.50CVS: Import to CVS6-286.51CVS: Log In to CVS6-286.52Data Import Wizard6-296.52.1Data Preview6-296.52.2Import Method6-306.52.2.1Load Options6-316.52.3Import Metadata Source6-316.52.4Choose Columns6-326.52.5Column port/Import Connections6-356.53.1Export Connections6-366.53.2Import Connections6-366.54Create/Edit Database Destination6-376.55Create/Edit Destination Group (Database or External)6-376.56Create/Edit Database Link6-386.57Create/Edit .58Create File Watcher6-406.59Create Filter6-41xiv
6.60Create Function or Procedure6-416.61Create/Edit Job6-426.61.1Job Details6-426.61.2Destination6-436.61.3Job s6-436.61.6Summary/SQL6-446.62Create/Edit Job Class6-446.63Create/Edit Materialized View Log6-456.64Create PL/SQL Package6-466.65Create Pluggable Database6-476.66Create/Edit Program6-476.67Create/Edit Role6-496.68Create/Edit Schedule6-506.69Create/Edit Sequence6-506.70Create SQL File6-516.71Create/Edit Synonym6-516.72Create Table (quick creation)6-526.73Create/Edit Table (with advanced options)6-536.73.1Columns pane6-546.73.2Constraints6-556.73.3Primary Key Constraint6-556.73.4Unique Constraints6-566.73.5Foreign Keys Constraints6-576.73.6Check Constraints6-576.73.7Indexes pane6-586.73.8In-Memory pane6-596.73.9Storage pane6-596.73.10Column Sequences pane6-606.73.11Table Properties pane6-606.73.12LOB Parameters pane6-606.73.13Partitioning pane6-626.73.14Subpartition Templates pane6-626.73.15Partition Definitions pane6-636.73.16Partition Sets pane6-636.73.17Index Organized Properties pane6-646.73.18External Table Properties pane6-656.73.19Comment pane6-656.73.20DDL pane6-656.73.21Hive Tables6-66xv
6.73.21.1Hive Tables: Partitions6-666.73.21.2Hive Tables: Buckets6-666.73.21.3Hive Tables: Skew6-666.73.21.4Hive Tables: Storage6-676.73.21.5Hive Tables: Table Properties6-676.74Storage Options6-676.75Create/Edit Tablespace6-686.75.1File Specifications tab6-686.75.2Properties tab6-696.75.3Default Parameters tab6-706.75.4DDL tab6-706.76Create Trigger6-706.77Create Type (User-Defined)6-716.78Create/Edit User6-726.78.1User tab6-726.78.2Granted Roles tab6-736.78.3System Privileges tab6-736.78.4Quotas tab6-736.78.5SQL tab6-736.79Create/Edit User Defined Report6-736.80Create/Edit User Defined Report Folder6-756.81Create/Edit View6-756.81.1SQL Query tab or pane6-766.81.2View Properties or Materialized View Properties pane6-766.81.3DDL tab or pane6-786.81.4Quick-Pick Objects pane6-786.81.5FROM Clause pane6-796.81.6SELECT Clause pane6-806.81.7WHERE Clause pane6-806.81.8GROUP BY Clause pane6-806.81.9HAVING Clause pane6-816.81.10ORDER BY Clause pane6-816.82Create Window6-816.83Create Window Group6-826.84Create XML Document from XML Schema6-836.85Create XML Schema6-836.86Custom Filters6-846.87Customize Toolbars6-846.88Data Pump Export6-846.88.1Source page6-846.88.2Tablespaces page6-85xvi
6.88.3Schemas page6-856.88.4Tables page6-856.88.5Filter page6-856.88.6Table Data page6-856.88.7Options page6-856.88.8Output Files page6-856.88.9OSS Transfer page6-866.88.10Job Schedule page6-866.88.11Summary page6-876.89Data Pump Import6-876.89.1Type page6-876.89.2Tablespaces page6-876.89.3Schemas page6-876.89.4Tables page6-886.89.5Filter page6-886.89.6Table Data page6-886.89.7Remapping page6-886.89.8Options page6-886.89.9Job Schedule page6-886.89.106.90Summary pageDatabase Copy6-886-896.90.1Source/Destination page6-896.90.2Object Types page6-896.90.3Select Schemas page6-906.90.4Select Tablespace page6-906.90.5Specify Objects page6-906.90.6Specify Data page6-906.90.7Summary page6-90Database Differences6-906.916.91.1Source/Destination page6-906.91.2Types to Diff page6-926.91.3Specify Objects page6-926.91.4Summary page6-926.92Database Export (Unload Database Objects and Data)6-926.92.1Source/Destination page6-936.92.2Types to Export page6-946.92.3Specify Objects page6-946.92.4Specify Data page6-946.92.5Export Summary page6-946.93DDL Panel for Creating or Editing an Object6-956.94Debugger - Attach to JPDA6-95xvii
6.95Deploy or Import Application6-956.96Deploy Objects to 6.3Transfer6-976.96.4Deploy DDL6-976.96.5Deploy Data6-976.96.6Unsupported Cart Object for Cloud Deployment6-976.96.7Other Errors (Invalid or Missing Entries)6-986.97Describe Object Window6-986.98Diff Objects6-986.99Drop Pluggable Database6-1006.100Drop REST Services for Schema6-1006.101Edit/View Value (Data or Table Column)6-1006.102Enter Bind Values6-1016.103Erase from Disk6-1016.104Error Writing to Export File6-1016.105Export Error6-1016.106Export Data6-1026.107Export Objects6-1026.108Export Resource Module, Privilege, and Role6-1036.109Export: Unique Names Warning6-1036.110External Locator Configuration6-1036.111External Tools6-1046.112Create/Edit External Tool6-1046.112.1Program -1056.112.4Availability6-1056.113Choose Offline Options6-1056.114Edit Font Location6-1066.115Edit Header or Footer (PDF Formatting)6-1066.116Edit Join6-1066.117Extract Variable/Function/CTE for Refactoring6-1076.118Feature Missing6-1096.119Feature Required6-1096.120File Processing6-1106.121Filter6-1106.122Filter Object Types6-1116.123Filter Schemas6-1116.124Filter Error6-111xviii
6.125Find/Highlight6-1116.126Git: Add6-1126.127Git: Add All6-1126.128Git: Add to .gitignore File6-1126.129Git: Checkout Revision6-1126.130Git: Clone from Git6-1136.131Git: Commit6-1146.132Git: Commit All6-1146.133Git: Create Branch6-1156.134Git: Create Tag6-1156.135Git: Export Committed Changes6-1166.136Git: Export Uncommitted Changes6-1166.137Git: Fetch from Git6-1166.138Git: Initialize Repository6-1176.139Git: Merge6-1186.140Git: Pull from Git6-1186.141Git: Push to Git6-1196.142Git: Revert6-1206.143Insert Macro6-1206.144Externally Modified Files6-1206.145Find/Replace Text6-1206.146Find Result6-1216.147Format Properties (Advanced Formatting)6-1216.148Generate Patch6-1226.149Go to Bookmark6-1226.150Go to Line Number6-1226.151Go to Line Number: Error6-1226.152History6-1226.153Import Using Oracle Loader for Hadoop6-1236.154Import Using Oracle SQL Connector for HDFS6-1246.155Install/Run Oracle REST Data Services6-1266.155.1ORDS File Locations6-1266.155.2Database Connection6-1266.155.3Database Options6-1276.155.4Select Tablespace6-1276.155.5PL/SQL Gateway6-1276.155.6APEX RESTful Services6-1276.155.7Run Standalone Mode6-1286.155.8ORDS Users6-1286.155.9Summary6-128Install SQL Translator6-1296.156xix
6.156.1Installing a Translator and Creating a Profile: Usage Notes6-1296.157Invalid Database Version6-1306.158Load Extension6-1306.159Load Keyboard Scheme6-1306.160LOB Descriptors6-1316.161Maintain Spatial Metadata6-1316.162Manage Columns6-1326.163Manage Connections (REST)6-1326.164Manage Features and Updates6-1336.165Map Connection6-1346.166Merge Migration Projects6-1346.167Modify Pluggable State6-1346.168Modify Value6-1356.169Data Move Details6-1356.170New/Edit Change Set6-1366.171New Procedure (Refactoring)6-1366.172New/Edit Local or Remote Port Forward6-1366.173Edit SSH Connection6-1376.174No Lock6-1376.175No Object Found6-1376.176No Object Selected6-1376.177Object Preferences6-1386.178Offline Generation Error - Destination Directory6-1386.179Open File6-1386.180Oracle-Only Report6-1386.181Paste6-1386.182Perforce: Add Files to Perforce6-1386.183Perforce: Connection6-1396.184Perforce: Create Changelist6-1396.185Perforce: Delete Files6-1396.186Perforce: Login6-1406.187Perforce: Open Files for Edit6-1406.188Perforce: Revert Files6-1406.189Perforce: Sync Files6-1416.190Perforce: Submit Changelist6-1416.191Plug In Pluggable Database6-1426.192Print Preview6-1436.193Privilege Warning for Migration6-1436.194Publish to REST6-1436.195Recent Files6-1436.196Delete or Truncate Repository6-144xx
6.196.1Error Truncating Repository6-1446.197Rename Local Variable6-1446.198Rename Tab6-1446.199Rename Procedure6-1446.200Repair (Validate) Oracle REST Data Services6-1456.201REST Data Services Connection6-1456.202REST Data Services Connection: Authentication Failed6-1466.203REST Data Services Connection: Remove Connection6-1476.204RESTful Services Wizard (Auto-Enable REST Access)6-1486.204.1Specify Details6-1486.204.2RESTful Summary6-1486.205RESTful Services Wizard and Object Dialog Boxes6-1496.205.1Resource Module6-1506.205.2Resource Template6-1506.205.3Resource Handler6-1516.205.3.16.205.4Resource Handler Editing Pane6-152RESTful Summary6-1526.206RESTful Services Connection6-1526.207RESTful Services Privilege6-1536.208RESTful Services Roles6-1536.209Select Current Repository6-1536.210Cannot Capture Table6-1546.211Report Panel6-1546.212Reset Expired Password (Enter New Password)6-1546.213Revision Lister6-1546.214Run/Debug/Profile PL/SQL6-1546.215Create/Edit Breakpoint6-1556.215.1Definition tab6-1556.215.2Conditions tab6-1556.215.3Actions tab6-1566.216Save/Save As, or Select File6-1566.217Save or Open Cart Tool Configuration6-1566.218Save Files6-1576.219Unable to Save Files6-1576.220Save Style Settings6-1576.221Schema Differences Source or Destination Error6-1576.222Script Execution Failed6-1576.223Script Generation Complete6-1576.224Set Data Mapping6-1586.225Add/Edit Rule6-1586.226Set Encoding6-158xxi
6.227Set Pause Continue6-1596.228Shared Wizard Pages6-1596.228.1Types6-1596.228.2Specify 29Sign In (checking for updates)6-1606.230Single Record View6-1606.231Save Snippet (User-Defined)6-1616.232Edit Snippets (User-Defined)6-1616.233Show SQL6-1616.234Start Date, End Date, Repeat Interval, Comments (Scheduler)6-1626.235Subversion: Add Property6-1626.236Subversion: Add to Source Control6-1626.237Subversion: Apply Patch6-1626.238Subversion: Branch/Tag6-1636.239Subversion: Check Out from Subversion6-1636.240Subversion: Commit Resources6-1646.241Subversion: Commit Working Copy6-1646.242Subversion: Confirm Checkout6-1656.243Subversion: Create Remote Directory6-1656.244Subversion: Create Subversion Repository6-1656.245Subversion: Create/Edit Subversion Connection6-1666.246Subversion: Delete Resources6-1666.247Subversion: Edit Configuration File6-1666.248Subversion: Export Files6-1676.249Subversion: Export Subversion Connections6-1676.250Subversion: Ignore6-1676.251Subversion: Import Subversion Connections6-1676.252Subversion: Import to 5Summary6-1696.253Subversion: Lock Resources6-1696.254Subversion: Merge6-1696.255Subversion: Pending Changes6-1706.256Subversion: Properties6-1716.257Subversion: Remove from Subversion6-1716.258Subversion: Repository Browser6-171xxii
6.259Subversion: Revert Local Changes6-1716.260Subversion: Switch6-1726.261Subversion: Unlock Resources6-1726.262Subversi
Changes in Oracle SQL Developer Release 18.1 xlviii 1 SQL Developer Concepts and Usage 1.1 About SQL Developer 1-2 1.2 Installing and Getting Started with SQL Developer 1-2 1.3 SQL Developer User Interface 1-3 1.3.1 Menus for SQL Developer
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
Oracle is a registered trademark and Developer/2000, Oracle8, Oracle Application Object Library, Oracle Alert, Oracle Financials, Oracle Quality, Oracle Workflow, Oracle Work in Process, SQL*Forms, SQL*Plus, SQL*AMX, SQL*Report, and SQL*ReportWriter are
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Logical SQL statements understood by the Oracle BI Server. Logical SQL includes standard SQL, plus special functions (SQL extensions) such as AGO, TODATE, EVALUATE, and others. Logical SQL queries resolve to Presentation layer objects. This guide contains the following topics: About Logical SQL in Oracle Business Intelligence SQL Syntax .
Server 2005 , SQL Server 2008 , SQL Server 2008 R2 , SQL Server 2012 , SQL Server 2014 , SQL Server 2005 Express Edition , SQL Server 2008 Express SQL Server 2008 R2 Express , SQL Server 2012 Express , SQL Server 2014 Express .NET Framework 4.0, .NET Framework 2.0,
SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact- SQL). T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capab
MS SQL Server: MS SQL Server 2017, MS SQL Server 2016, MS SQL Server 2014, MS SQL Server 2012, MS SQL Server 2008 R2, 2008, 2008 (64 bit), 2008 Express, MS SQL Server 2005, 2005 (64 bit), 2005 Express, MS SQL Server 2000, 2000 (64 bit), 7.0 and mixed formats. To install the software, follow the steps: 1. Double-click Stellar Repair for MS SQL.exe.
As of Oracle release 9i Version 2, Oracle has adopted the SQL99 standard of the SQL language. For a complete listing of all SQL and SQL*Plus commands, please refer to the Oracle Database SQL Reference and SQL*Plus reference manuals. These books and more are available in the
