Download here: http://gg.gg/x1vw2
Skip to end of metadataGo to start of metadata
To interact with an Oracle Database Server as a developer, you will need to use the Oracle SQL Developer software. This software is available free of charge from Oracle for Windows, Macintosh and Linux operating systems.
Oracle SQL Developer requires the Java Development Kit (JDK) to run. If you are using Windows, you have the option to download a version of SQL Developer that includes the JDK. To do this, pllease follow the simple installation instructions below.
SQL Developer installation setup doesn’t start Dear Community, i have a problem to install the SQL Developer in Parallels on Windows 10. If I click on the setup icon, the installation setup. Afterwards in this SQL tutorial, I want to share with programmers the steps that I followed to install SQL Server 2019 on my Mac computer using docker image. Installing Docker for Mac OS. The first thing SQL developers should do is installing the Docker Desktop app on Mac OS. The installation steps are well described at docs.docker.com web portal.
If you are using Macintosh or Linux or want to specify a separate JDK to use on Windows, then follow the two part installation instructions below.Installing Sql Developer On Parallels For Mac Download
If you encounter any error messages, please refer to the troubleshooting section at the end of this document.
*If the Self Service application is installed on the Mac computer, it can be used to install SQL Developer. The benefit of installing from Self Service is that SQL Developer is preconfigured to work with the Data Warehouse. If Self Service is not available on the computer, SQL Developer can be manually installed and configured.
*Installing Oracle SQL Developer To interact with an Oracle Database Server as a developer, you will need to use the Oracle SQL Developer software. This software is available free of charge from Oracle for Windows, Macintosh and Linux operating systems. Oracle SQL Developer.
Simple installation for Windows-64 bit version
*Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the 64-bit version of Oracle SQL Developer. The 32/64 bit installer will also work, but you should use the 64-bit version specifically since it also includes Java. if you want to use the 32/64-bit installer instead, then you will need to follow the two-part installation process discussed in the next section.
*There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish.
*The first time you launch Oracle SQL Developer you will also be prompted to associate certain file types with it. You should select all file types and click ok.
*Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
Download and Install Java SDK
*Download the latest version of Java Development Kit from http://www.oracle.com/technetwork/java/javase/downloads/index.html and run it.
*We recommend you accept all default options. When prompted for a location to install the JDK, whether you keep the default or change it, make a note of where you install it, since the first time Oracle SQL Developer runs it will ask you where JDK is installed. Download and Install Oracle Developer
*Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the version of Oracle SQL Developer you require.
*There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish.
*The first time you launch Oracle SQL Developer you will be promoted to tell it the location of your installed JDK. Use the Browse button to browse to the the location of Java.exe. For example: a typical installation path for JDK version 7 on Windows is C:Program FilesJavajrebinjava.exe’
*The first time you launch Oracle SQL Developer you will also be prompted to associate certain file types with it. You should all file types and click ok.
*Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
*Even if you downloaded and installed the latest version of Java, you may receive a message similar to the following that your version of Java is unsupported. We recommend you check the box the skip this message from now on and click yes to continue.
*Depending on the version of JDK you have and what version of SQL Developer you downloaded you may receive a message that MSVCR100.dll (or a similarly named DLL) is missing. This DLL is a file that you should find in the same directory as Java.exe. Simply COPY that file and PASTE it into the same directory as SqlDeveloper.exe. Then relaunch Oracle SQL Developer.
Note:This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool.
If you plan to use SQL Developer as part of the Oracle Database release 11 installation, see the Oracle Database installation documentation.
Please read the information in this chapter before you install Oracle SQL Developer. This chapter contains the following major sections:1.1 SQL Developer System Recommendations
This section describes the recommended minimum values for CPU, memory, display, disk storage, and other resources on the supported systems.
Table 1-1 Recommendations for Windows SystemsResourceRecommended Minimum Value
Operating System
Windows 2000-Service Pack 4
Windows XP-Service Pack 2
Windows 2003 R2
CPU Type and Speed
Pentium IV 2 GHz MHz or faster
Memory
1 GB RAM
Display
65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space
42 MB if you already have JDK 1.5
110 MB if you do not have JDK 1.5
Java SDK
JDK 5.0 Update 6 or later for Windows, available at: http://www.javasoft.com (If you do not have this SDK installed, you can use SQL Developer, but you must download and install the kit for Windows systems with no Java SDK or with a Sun Java SDK release lower than 5.0.)
Table 1-2 Recommendations for Linux SystemsResourceRecommended Minimum Value
Operating System
Red Hat Enterprise Linux 3.0
Fedora Core 4
CPU Type and Speed
Pentium IV 2 GHz or faster
Memory
1 GB RAM
Display
65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space
110 MB
Java SDK
JDK 5.0 Update 6 or later for Linux, available at: http://www.javasoft.com
Table 1-3 Recommendations for Mac OS X SystemsResourceRecommended Minimum Value
Operating System
Apple Mac OS X Version 10.4.x
CPU Type and Speed
Dual 1.25 GHz G4/G5 (1 GHz G4 minimum)
Memory
1.5 GB RAM (1 GB minimum)
Display
’Thousands’ of colors
Hard Drive Space
110 MB
Java SDK
Sun J2SE 1.5 release 1, available at: http://www.apple.com/support/downloads/java2se50release1.html
1.2 Installing and Starting SQL Developer
This section contains subsections with instructions for installing SQL Developer on all supported systems.
SQL Developer does not require an installer. To install SQL Developer, you will need an unzip tool. You can download a free, cross-platform unzip tool, Info-Zip, available at http://www.info-zip.org/.
Important:Do not install SQL Developer into any existing ORACLE_HOME. You will not be able to uninstall it using Oracle Universal Installer.
Important:If you are using a pre-release (Early Adopter) version of SQL Developer, and if you want to be able to continue to use this pre-release version after installing the official release kit, you must unzip the official release kit into a different directory than the one used for the pre-release version.
If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle. This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer.
For Windows systems, there are two kits: one for systems on which the Sun Java SDK release 1.5.0_06 or later is installed, and another for systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06. Be sure to download the appropriate kit.
Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first.
The steps for installing SQL Developer depend on whether or not you will be using it on a Windows system that does not have the Sun Java SDK release 1.5.0_06 or later installed:
*
For a Windows system with the Sun Java release 1.5.0_06 or later installed, follow the instructions in Section 1.2.1.
*
For all other systems (Linux and Mac OS X systems, and Windows systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06 or later installed), follow the instructions in Section 1.2.2.1.2.1 Windows Systems with JDK5.0
To install and start SQL Developer on a Windows system on which the Sun Java J2SE JDK 5.0 (Update 6 or later) is installed, follow these steps:
*
Unzip the SQL Developer kit into a folder (directory) of your choice (for example, C:Program Files). This folder will be referred to as <sqldeveloper_install>.
Unzipping the SQL Developer kit causes a folder named sqldeveloper to be created under the <sqldeveloper_install> folder (for example, C:Program Filessqldeveloper). It also causes many files and folders to be placed in and under that directory.
*
To start SQL Developer, go to <sqldeveloper_install>sqldeveloper, and double-click sqldeveloper.exe.
If you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For example, the path might have a name similar to C:Program FilesJavajdk1.5.0_06binjava.exe.
After SQL Developer starts, you can connect to any database by right-clicking the Connections node in the Connections Navigator and selecting New Connection. Alternatively, if you have any exported connections (see Section 1.4 or Section 1.10), you can import these connections and use them.
You can learn about SQL Developer by clicking Help, then Table of Contents, and reading the help topics under SQL Developer Concepts and Usage.1.2.2 Linux and Mac OS X Systems, and Windows Systems without JDK 5.0
SQL Developer requires that the Sun Java J2SE JDK 5.0 (Update 6 or later) be installed on the system. If you need to install this JDK, go to http://java.sun.com/j2se/1.5.0/download.jsp and click the link for downloading JDK 5.0 Update 12 (or the most recent available update).
To install and start SQL Developer, follow these steps:
*
Unzip the SQL Developer kit into a directory (folder) of your choice. This directory location will be referred to as <sqldeveloper_install>.
Unzipping the SQL Developer kit causes a directory named sqldeveloper to be created under the <sqldeveloper_install> directory. It also causes many files and folders to be placed in and under that directory.
*
To start SQL Developer, go to the sqldeveloper directory under the <sqldeveloper_install> directory, and do one of the following, as appropriate for your operating system:
On Linux and Mac OS X systems, run sh sqldeveloper.sh.
On Windows systems, double-click sqldeveloper.exe.
After SQL Developer starts, you can connect to any database by right-clicking the Connections node in the Connections Navigator and selecting New Connection. Alternatively, if you have any exported connections (see Section 1.4 or Section 1.10), you can import these connections and use them.
You can learn about SQL Developer by clicking Help, then Table of Contents, and reading the help topics under SQL Developer Concepts and Usage.1.3 Migrating User Settings from a Previous Release
The first time you start SQL Developer after installing it or after adding any extensions, you are asked if you want to migrate your user settings from a previous release. (This occurs regardless of whether there was a previous release on your system.)
Note:Migration of user settings is supported only from SQL Developer Release 1.1.3 or later to Release 1.5.
These settings refer to database connections, reports, and certain SQL Developer user preferences that you set in a previous version by clicking Tools and then Preferences. However, some user preferences are not saved, and you must re-specify these using the new release.
To migrate user settings from a previous SQL Developer release:
*
Unzip the Release 1.5 kit into an empty directory (folder). Do not delete or overwrite the directory into which you unzipped the kit for the previous SQL Developer release.
*
When you start SQL Developer Release 1.5, click Yes when asked if you want to migrate settings from a previous release.
*
In the dialog box that is displayed, do not accept the default location for the settings. Instead, specify the location of your settings for the previous release, which might be a folder whose path ends with sqldevelopersqldevelopersystem or Documents and Settings<user>Application DataSQL Developersystem.
See also Section 1.4, ’Migrating Information from Previous Releases’.1.4 Migrating Information from Previous Releases
If you have used a previous release of SQL Developer, you may want to preserve database connections that you have been using. To preserve database connections, save your existing database connections in an XML file. To save the connections, right-click the Connections node in the Connections Navigator and select Export Connections. After you complete the installation described in this guide, you can use those connections by right-clicking the Connections node in the Connections Navigator and selecting Import Connections
If you want to use any user-defined reports or the SQL history from a previous version, see Section 1.5 for information about where these are located. If you have user-defined reports and SQL history from Release 1.0, they are modified by any later SQL Developer release to a format that is different from and incompatible with Release 1.0.
SQL Developer preferences (specified by clicking Tools and then Preferences) from a pre-release version of the current release cannot currently be saved and reused; you must re-specify any desired preferences.
Note:If you want to uninstall your pre-release version of SQL Developer before installing this release, see Section 1.10, ’Uninstalling SQL Developer’.1.5 Location of User-Related Information
SQL Developer stores user-related information in several places, with the specific location depending on the operating system and certain environment specifications. User-related information includes user-defined reports, user-defined snippets, SQL Worksheet history, code templates, and SQL Developer user preferences. In most cases, your user-related information is stored outside the SQL Developer installation directory hierarchy, so that it is preserved if you delete that directory and install a new version.
The user-related information is stored in or under the following location:
*
On Windows systems: the HOME environment variable location, if defined; otherwise the SQLDEVELOPER_USER_DIR location, if defined; otherwise as indicated in the following table
*
On Linux and Mac OS X systems: the SQLDEVELOPER_USER_DIR location, if defined; otherwise as indicated in the following table
The following table shows the typical default locations (under a directory or in a file) for specific types of resources on different operating systems. (Note the period in the name of any directory named .sqldeveloper.)
Table 1-4 Default Locations for User-Related InformationResource TypeSystem (Windows, Linux, or Mac OS X)
User-defined reports
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserReports.xml
Linux or Mac OS X: ~/.sqldeveloper/UserReports.xml
User-defined snippets
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserSnippets.xml
Linux: ~/.sqldeveloper/ UserSnippets.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/UserSnippets.xml
SQL history
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperSqlHistory.xml
Linux: ~/.sqldeveloper/ SqlHistory.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ SqlHistory.xml
Code templates
Windows: C:Documents and Settings<user-name>Application DataSQL Developer CodeTemplate.xml
Linux: ~/.sqldeveloper/ CodeTemplate.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ CodeTemplate.xml
SQL Developer user preferences
Windows: C:Documents and Settings<user-name>Application DataSQL Developersystemn.n.n.n.n
Linux or Mac OS X: ~/.sqldeveloper/systemn.n.n.n.n
To specify a nondefault SQLDEVELOPER_USER_DIR location, do either of the following: 1961 corvette soft top installation.
*
Set the SQLDEVELOPER_USER_DIR environment variable to specify another directory path.
*
Edit the <sqldeveloper_install>sqldevelopersqldeveloperbinsqldeveloper.conf file and substitute the desired directory path for SQLDEVELOPER_USER_DIR in the following line:
If you want to prevent other users from accessing your user-specific SQL Developer information, you must ensure that the appropriate permissions are set on the directory where that information is stored or on a directory above it in the path hierarchy. For example, on a Windows system you may want to ensure that the SQL Developer folder and the <user-name>Application DataSQL Developer folder under Documents and Settings are not shareable; and on a Linux or Mac OS X system you may want to ensure that the ~/.sqldeveloper directory is not world-readable.1.6 Database Certification for SQL Developer (Oracle and Third-Party)
This section describes Oracle and non-Oracle (third-party) databases that are certified for use with SQL Developer.
Table 1-5 lists the Oracle database certifications.
Table 1-5 Oracle Database Certification for SQL DeveloperProductReleases
Oracle Database
Oracle9i (9.2.0.1 and later)
Oracle10g
Oracle11g
Oracle Database Express Edition
Oracle10g
SQL Developer can be used to view metadata and data of several non-Oracle (third-party) databases. Table 1-6 lists the third-party database certifications.
Table 1-6 Non-Oracle (Third-Party) Database Certification for SQL DeveloperDatabaseReleasesNotes
Microsoft Access
Access 97
Access 2000
Access XP (2002)
Access 2003
For any Access release:
https://diarynote-jp.indered.space
Skip to end of metadataGo to start of metadata
To interact with an Oracle Database Server as a developer, you will need to use the Oracle SQL Developer software. This software is available free of charge from Oracle for Windows, Macintosh and Linux operating systems.
Oracle SQL Developer requires the Java Development Kit (JDK) to run. If you are using Windows, you have the option to download a version of SQL Developer that includes the JDK. To do this, pllease follow the simple installation instructions below.
SQL Developer installation setup doesn’t start Dear Community, i have a problem to install the SQL Developer in Parallels on Windows 10. If I click on the setup icon, the installation setup. Afterwards in this SQL tutorial, I want to share with programmers the steps that I followed to install SQL Server 2019 on my Mac computer using docker image. Installing Docker for Mac OS. The first thing SQL developers should do is installing the Docker Desktop app on Mac OS. The installation steps are well described at docs.docker.com web portal.
If you are using Macintosh or Linux or want to specify a separate JDK to use on Windows, then follow the two part installation instructions below.Installing Sql Developer On Parallels For Mac Download
If you encounter any error messages, please refer to the troubleshooting section at the end of this document.
*If the Self Service application is installed on the Mac computer, it can be used to install SQL Developer. The benefit of installing from Self Service is that SQL Developer is preconfigured to work with the Data Warehouse. If Self Service is not available on the computer, SQL Developer can be manually installed and configured.
*Installing Oracle SQL Developer To interact with an Oracle Database Server as a developer, you will need to use the Oracle SQL Developer software. This software is available free of charge from Oracle for Windows, Macintosh and Linux operating systems. Oracle SQL Developer.
Simple installation for Windows-64 bit version
*Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the 64-bit version of Oracle SQL Developer. The 32/64 bit installer will also work, but you should use the 64-bit version specifically since it also includes Java. if you want to use the 32/64-bit installer instead, then you will need to follow the two-part installation process discussed in the next section.
*There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish.
*The first time you launch Oracle SQL Developer you will also be prompted to associate certain file types with it. You should select all file types and click ok.
*Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
Download and Install Java SDK
*Download the latest version of Java Development Kit from http://www.oracle.com/technetwork/java/javase/downloads/index.html and run it.
*We recommend you accept all default options. When prompted for a location to install the JDK, whether you keep the default or change it, make a note of where you install it, since the first time Oracle SQL Developer runs it will ask you where JDK is installed. Download and Install Oracle Developer
*Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the version of Oracle SQL Developer you require.
*There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish.
*The first time you launch Oracle SQL Developer you will be promoted to tell it the location of your installed JDK. Use the Browse button to browse to the the location of Java.exe. For example: a typical installation path for JDK version 7 on Windows is C:Program FilesJavajrebinjava.exe’
*The first time you launch Oracle SQL Developer you will also be prompted to associate certain file types with it. You should all file types and click ok.
*Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
*Even if you downloaded and installed the latest version of Java, you may receive a message similar to the following that your version of Java is unsupported. We recommend you check the box the skip this message from now on and click yes to continue.
*Depending on the version of JDK you have and what version of SQL Developer you downloaded you may receive a message that MSVCR100.dll (or a similarly named DLL) is missing. This DLL is a file that you should find in the same directory as Java.exe. Simply COPY that file and PASTE it into the same directory as SqlDeveloper.exe. Then relaunch Oracle SQL Developer.
Note:This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool.
If you plan to use SQL Developer as part of the Oracle Database release 11 installation, see the Oracle Database installation documentation.
Please read the information in this chapter before you install Oracle SQL Developer. This chapter contains the following major sections:1.1 SQL Developer System Recommendations
This section describes the recommended minimum values for CPU, memory, display, disk storage, and other resources on the supported systems.
Table 1-1 Recommendations for Windows SystemsResourceRecommended Minimum Value
Operating System
Windows 2000-Service Pack 4
Windows XP-Service Pack 2
Windows 2003 R2
CPU Type and Speed
Pentium IV 2 GHz MHz or faster
Memory
1 GB RAM
Display
65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space
42 MB if you already have JDK 1.5
110 MB if you do not have JDK 1.5
Java SDK
JDK 5.0 Update 6 or later for Windows, available at: http://www.javasoft.com (If you do not have this SDK installed, you can use SQL Developer, but you must download and install the kit for Windows systems with no Java SDK or with a Sun Java SDK release lower than 5.0.)
Table 1-2 Recommendations for Linux SystemsResourceRecommended Minimum Value
Operating System
Red Hat Enterprise Linux 3.0
Fedora Core 4
CPU Type and Speed
Pentium IV 2 GHz or faster
Memory
1 GB RAM
Display
65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space
110 MB
Java SDK
JDK 5.0 Update 6 or later for Linux, available at: http://www.javasoft.com
Table 1-3 Recommendations for Mac OS X SystemsResourceRecommended Minimum Value
Operating System
Apple Mac OS X Version 10.4.x
CPU Type and Speed
Dual 1.25 GHz G4/G5 (1 GHz G4 minimum)
Memory
1.5 GB RAM (1 GB minimum)
Display
’Thousands’ of colors
Hard Drive Space
110 MB
Java SDK
Sun J2SE 1.5 release 1, available at: http://www.apple.com/support/downloads/java2se50release1.html
1.2 Installing and Starting SQL Developer
This section contains subsections with instructions for installing SQL Developer on all supported systems.
SQL Developer does not require an installer. To install SQL Developer, you will need an unzip tool. You can download a free, cross-platform unzip tool, Info-Zip, available at http://www.info-zip.org/.
Important:Do not install SQL Developer into any existing ORACLE_HOME. You will not be able to uninstall it using Oracle Universal Installer.
Important:If you are using a pre-release (Early Adopter) version of SQL Developer, and if you want to be able to continue to use this pre-release version after installing the official release kit, you must unzip the official release kit into a different directory than the one used for the pre-release version.
If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle. This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer.
For Windows systems, there are two kits: one for systems on which the Sun Java SDK release 1.5.0_06 or later is installed, and another for systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06. Be sure to download the appropriate kit.
Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first.
The steps for installing SQL Developer depend on whether or not you will be using it on a Windows system that does not have the Sun Java SDK release 1.5.0_06 or later installed:
*
For a Windows system with the Sun Java release 1.5.0_06 or later installed, follow the instructions in Section 1.2.1.
*
For all other systems (Linux and Mac OS X systems, and Windows systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06 or later installed), follow the instructions in Section 1.2.2.1.2.1 Windows Systems with JDK5.0
To install and start SQL Developer on a Windows system on which the Sun Java J2SE JDK 5.0 (Update 6 or later) is installed, follow these steps:
*
Unzip the SQL Developer kit into a folder (directory) of your choice (for example, C:Program Files). This folder will be referred to as <sqldeveloper_install>.
Unzipping the SQL Developer kit causes a folder named sqldeveloper to be created under the <sqldeveloper_install> folder (for example, C:Program Filessqldeveloper). It also causes many files and folders to be placed in and under that directory.
*
To start SQL Developer, go to <sqldeveloper_install>sqldeveloper, and double-click sqldeveloper.exe.
If you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For example, the path might have a name similar to C:Program FilesJavajdk1.5.0_06binjava.exe.
After SQL Developer starts, you can connect to any database by right-clicking the Connections node in the Connections Navigator and selecting New Connection. Alternatively, if you have any exported connections (see Section 1.4 or Section 1.10), you can import these connections and use them.
You can learn about SQL Developer by clicking Help, then Table of Contents, and reading the help topics under SQL Developer Concepts and Usage.1.2.2 Linux and Mac OS X Systems, and Windows Systems without JDK 5.0
SQL Developer requires that the Sun Java J2SE JDK 5.0 (Update 6 or later) be installed on the system. If you need to install this JDK, go to http://java.sun.com/j2se/1.5.0/download.jsp and click the link for downloading JDK 5.0 Update 12 (or the most recent available update).
To install and start SQL Developer, follow these steps:
*
Unzip the SQL Developer kit into a directory (folder) of your choice. This directory location will be referred to as <sqldeveloper_install>.
Unzipping the SQL Developer kit causes a directory named sqldeveloper to be created under the <sqldeveloper_install> directory. It also causes many files and folders to be placed in and under that directory.
*
To start SQL Developer, go to the sqldeveloper directory under the <sqldeveloper_install> directory, and do one of the following, as appropriate for your operating system:
On Linux and Mac OS X systems, run sh sqldeveloper.sh.
On Windows systems, double-click sqldeveloper.exe.
After SQL Developer starts, you can connect to any database by right-clicking the Connections node in the Connections Navigator and selecting New Connection. Alternatively, if you have any exported connections (see Section 1.4 or Section 1.10), you can import these connections and use them.
You can learn about SQL Developer by clicking Help, then Table of Contents, and reading the help topics under SQL Developer Concepts and Usage.1.3 Migrating User Settings from a Previous Release
The first time you start SQL Developer after installing it or after adding any extensions, you are asked if you want to migrate your user settings from a previous release. (This occurs regardless of whether there was a previous release on your system.)
Note:Migration of user settings is supported only from SQL Developer Release 1.1.3 or later to Release 1.5.
These settings refer to database connections, reports, and certain SQL Developer user preferences that you set in a previous version by clicking Tools and then Preferences. However, some user preferences are not saved, and you must re-specify these using the new release.
To migrate user settings from a previous SQL Developer release:
*
Unzip the Release 1.5 kit into an empty directory (folder). Do not delete or overwrite the directory into which you unzipped the kit for the previous SQL Developer release.
*
When you start SQL Developer Release 1.5, click Yes when asked if you want to migrate settings from a previous release.
*
In the dialog box that is displayed, do not accept the default location for the settings. Instead, specify the location of your settings for the previous release, which might be a folder whose path ends with sqldevelopersqldevelopersystem or Documents and Settings<user>Application DataSQL Developersystem.
See also Section 1.4, ’Migrating Information from Previous Releases’.1.4 Migrating Information from Previous Releases
If you have used a previous release of SQL Developer, you may want to preserve database connections that you have been using. To preserve database connections, save your existing database connections in an XML file. To save the connections, right-click the Connections node in the Connections Navigator and select Export Connections. After you complete the installation described in this guide, you can use those connections by right-clicking the Connections node in the Connections Navigator and selecting Import Connections
If you want to use any user-defined reports or the SQL history from a previous version, see Section 1.5 for information about where these are located. If you have user-defined reports and SQL history from Release 1.0, they are modified by any later SQL Developer release to a format that is different from and incompatible with Release 1.0.
SQL Developer preferences (specified by clicking Tools and then Preferences) from a pre-release version of the current release cannot currently be saved and reused; you must re-specify any desired preferences.
Note:If you want to uninstall your pre-release version of SQL Developer before installing this release, see Section 1.10, ’Uninstalling SQL Developer’.1.5 Location of User-Related Information
SQL Developer stores user-related information in several places, with the specific location depending on the operating system and certain environment specifications. User-related information includes user-defined reports, user-defined snippets, SQL Worksheet history, code templates, and SQL Developer user preferences. In most cases, your user-related information is stored outside the SQL Developer installation directory hierarchy, so that it is preserved if you delete that directory and install a new version.
The user-related information is stored in or under the following location:
*
On Windows systems: the HOME environment variable location, if defined; otherwise the SQLDEVELOPER_USER_DIR location, if defined; otherwise as indicated in the following table
*
On Linux and Mac OS X systems: the SQLDEVELOPER_USER_DIR location, if defined; otherwise as indicated in the following table
The following table shows the typical default locations (under a directory or in a file) for specific types of resources on different operating systems. (Note the period in the name of any directory named .sqldeveloper.)
Table 1-4 Default Locations for User-Related InformationResource TypeSystem (Windows, Linux, or Mac OS X)
User-defined reports
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserReports.xml
Linux or Mac OS X: ~/.sqldeveloper/UserReports.xml
User-defined snippets
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperUserSnippets.xml
Linux: ~/.sqldeveloper/ UserSnippets.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/UserSnippets.xml
SQL history
Windows: C:Documents and Settings<user-name>Application DataSQL DeveloperSqlHistory.xml
Linux: ~/.sqldeveloper/ SqlHistory.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ SqlHistory.xml
Code templates
Windows: C:Documents and Settings<user-name>Application DataSQL Developer CodeTemplate.xml
Linux: ~/.sqldeveloper/ CodeTemplate.xml
Mac OS X: /Users/<Your user>/Library/Application Support/ SQLDeveloper/ CodeTemplate.xml
SQL Developer user preferences
Windows: C:Documents and Settings<user-name>Application DataSQL Developersystemn.n.n.n.n
Linux or Mac OS X: ~/.sqldeveloper/systemn.n.n.n.n
To specify a nondefault SQLDEVELOPER_USER_DIR location, do either of the following: 1961 corvette soft top installation.
*
Set the SQLDEVELOPER_USER_DIR environment variable to specify another directory path.
*
Edit the <sqldeveloper_install>sqldevelopersqldeveloperbinsqldeveloper.conf file and substitute the desired directory path for SQLDEVELOPER_USER_DIR in the following line:
If you want to prevent other users from accessing your user-specific SQL Developer information, you must ensure that the appropriate permissions are set on the directory where that information is stored or on a directory above it in the path hierarchy. For example, on a Windows system you may want to ensure that the SQL Developer folder and the <user-name>Application DataSQL Developer folder under Documents and Settings are not shareable; and on a Linux or Mac OS X system you may want to ensure that the ~/.sqldeveloper directory is not world-readable.1.6 Database Certification for SQL Developer (Oracle and Third-Party)
This section describes Oracle and non-Oracle (third-party) databases that are certified for use with SQL Developer.
Table 1-5 lists the Oracle database certifications.
Table 1-5 Oracle Database Certification for SQL DeveloperProductReleases
Oracle Database
Oracle9i (9.2.0.1 and later)
Oracle10g
Oracle11g
Oracle Database Express Edition
Oracle10g
SQL Developer can be used to view metadata and data of several non-Oracle (third-party) databases. Table 1-6 lists the third-party database certifications.
Table 1-6 Non-Oracle (Third-Party) Database Certification for SQL DeveloperDatabaseReleasesNotes
Microsoft Access
Access 97
Access 2000
Access XP (2002)
Access 2003
For any Access release:
https://diarynote-jp.indered.space
コメント