Oracle SQL Developer 19.4 Installation on OpenSuse Leap 15 and connect Oracle Database 19c

Опубликовано: 28 Сентябрь 2024
на канале: java frm

655

In this video we are going to see how to install SQL Developer 19.4 on OpenSuse Leap 15 using Oracle JDK 8 and connect Oracle Database 19c Enterprise Edition.

Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle.

SQL Developer also integrates interfaces into several related technologies, including Oracle Data Miner, Oracle OLAP, Oracle TimesTen In-Memory Database, and SQL Developer Data Modeler (read-only).

SQL Developer can be obtained from the below link.

https://www.oracle.com/tools/download...

Feature Enhancements
ORDS installer supports:
REST SQL and SQL Developer Web configuration
Custom JDBC urls and TNS
Allows non-SYSDBA user to install/upgrade, repair and uninstall ORDS
Bundled SQLcl now includes liquibase features
Include Orakafka ZIP in all distributions
Java Home updated to 8u221
Oracle NoSQL plugin updated to version 19.3.12
Database Copy added 'Ignore Storage' to avoid tablespace dependencies
Data Pump Wizard now supports encrypted DMP files
SQL Editor Code template options panel moved to code editor page
Code formatter new setting for number of commas to allow before a linebreak on PL/SQL call
Added SET CODESCAN to look for SQL Injection vulnerabilities
TABLE IMPORT enhanced to ignore virtual columns

JDK Support
Oracle SQL Developer 19.4 release requires Oracle Java 8 or 11/12/13, with a minimum version of 1.8 update 121.