Oracle SQL Developer 18.4 Installation on OpenSuse Leap 15 and connect Oracle Database 18c
In this video we are going to see how to install SQL Developer 18.4 on OpenSuse Leap 15 using Oracle JDK 8 and connect Oracle Database 18c 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 18.x offers built-in support for the Autonomous Data Warehouse Cloud Service (ADWC) . A key feature ADWC is the new end-to-end migration of AWS Redshift systems to our new Oracle Cloud Service. This new capability is driven by a simple wizard that eases the entire process. This includes the data definitions, offloading data into AWS S3, creating the new data structures in ADWC, then finishing up with loading the data directly from AWS S3.
Additional Feature Enhancements (18.x)
18.1
SQL Injection vulnerability warnings for your PL/SQL
Refreshed Welcome Page, includes new assistance for making connections
New Code Formatting style, Right-Aligned Keywords
Database Sharding option support enhancements
PL/Scope SQL Statements support (for versions 12.2 of Oracle Database and higher)
18.2
Faster Excel Imports
Faster Query Builder and ANSI -- Oracle JOIN syntax support
18.3
HTML Reports for Real Time SQL Monitoring
Nested Connection Folders
Cart Upload to OSS/Autonomous Cloud Services for multiple files/objects
https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-downloads-184-5458710.html
JDK Support
Oracle SQL Developer 18.4 release requires Oracle Java 8.