合 Oracle SQL Developer安装使用
Tags: Oracle工具客户端连接工具SQL Developer
- 简介
- 下载
- 官方文档
- SQL Developer Web
- 迁移第3方库到Oracle数据库
- Oracle SQL Developer Support FAQ (Doc ID 2345874.1)
- APPLIES TO:
- PURPOSE
- QUESTIONS AND ANSWERS
- 1. Is SQL Developer a "Free" product?
- 2. How to install SQL Developer?
- a. WINDOWS
- b. MAC
- c. LINUX
- 3. What are the Support guidelines and limits for this "Free" product?
- Oracle Customers
- Installation
- Configuration
- Help configuring a connection to the database
- Bugging and testcase reproduction
- Non-customers
- Oracle Tech Network
- All Customers
- 4. Can SQL Developer connect to non-Oracle databases for migration purposes?
- 5. Can I use the SQL Developer included with Oracle Database or Client Software products?
- 6. How are patches and enhancements (new features) handled in SQL Developer?
- 7. If there are no patches released for older versions, how are fixes for older versions implemented?
简介
官网:https://www.oracle.com/cn/database/sqldeveloper/
Oracle SQL Developer 是一个免费非开源的用以开发数据库应用程序的图形化工具,使用 SQL Developer 可以浏览数据库对象、运行 SQL 语句和脚本、编辑和调试 PL/SQL 语句。另外还可以创建执行和保存报表。该工具可以连接任何 Oracle 9.2.0.1 或者以上版本的 Oracle 数据库,支持 Windows、Linux 和 Mac OS X 系统。
在Oracle 19c之前, SQL Developer集成在Oracle数据库软件中,默认位置为
$ORACLE_HOME/sqldeveloper/
,Linux运行:
1 $ORACLE_HOME/sqldeveloper/sqldeveloper.sh从Oracle 19c版本开始, SQL Developer不再集成在Oracle数据库软件中,若想使用SQL Developer,则必须单独下载该软件。
下载
https://www.oracle.com/database/sqldeveloper/technologies/download/
官方文档
https://docs.oracle.com/en/database/oracle/sql-developer/index.html
- Oracle SQL Developer Release 23.1
- Oracle SQL Developer Release 22.2
- Oracle SQL Developer Release 21.4
- Oracle SQL Developer Release 20.4
- Oracle SQL Developer Release 20.2
- Oracle SQL Developer Release 19.4
- Oracle SQL Developer Release 19.2
- Oracle SQL Developer Release 19.1
- Oracle SQL Developer Release 18.4
- Oracle SQL Developer Release 18.3
- Oracle SQL Developer Release 18.2
- Oracle SQL Developer Release 18.1
- Oracle SQL Developer Release 17.4
- Oracle SQL Developer Release 17.3
- Oracle SQL Developer Release 17.2
- Oracle SQL Developer Release 4.2
SQL Developer Web
https://docs.oracle.com/en/database/oracle/sql-developer-web/
迁移第3方库到Oracle数据库
Oracle SQL Developer Support FAQ (Doc ID 2345874.1)
APPLIES TO:
Oracle SQL Developer - Version 1.0 to 22.2.1
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
PURPOSE
This FAQ answers the most common questions concerning installation, licensing, and support for Oracle SQL Developer.
QUESTIONS AND ANSWERS
1. Is SQL Developer a "Free" product?
Oracle SQL Developer is offered as a free product. Any user with a certified client platform may download the latest version from OTN (Oracle Tech Network). Developers should install on their personal Workstations (Windows, MAC, or Linux) since this is a GUI product and requires a display.