How to Install Oracle Sql Developer on Lubuntu 18.04 Bionic Easy Guide

June 8, 2018 | By the+gnu+linux+evangelist.

Install Oracle Sql Developer Lubuntu 18.04 Bionic

Hi! The Tutorial shows you How to Install Oracle SQL Developer for Lubuntu 18.04 Bionic LTS GNU/Linux.

And Oracle SQL Developer for Lubuntu 18.04 Bionic is a free Graphical Tool for Oracle 8i+ Database Development.

About the Key Features of Oracle SQL Developer:

  • SQL Worksheet: This is the primary interface for writing and executing SQL queries. It provides syntax highlighting, code completion, and the ability to execute multiple queries simultaneously.
  • PL/SQL Debugger: Developers can debug PL/SQL code directly within SQL Developer, allowing for step-by-step execution, breakpoints, and variable inspection.
  • Data Modeling: SQL Developer includes tools for designing and visualizing database schemas. Users can create and modify entity-relationship diagrams (ERDs), generate DDL scripts, and perform reverse engineering to generate ERDs from existing databases.
  • Database Administration: SQL Developer offers a range of features for database administration tasks, including managing users, tablespaces, roles, and privileges. It also provides monitoring capabilities for performance tuning and diagnostics.
  • Version Control Integration: SQL Developer integrates with version control systems such as Git, allowing developers to manage their database objects within a version-controlled environment.
  • Migration Tools: SQL Developer includes tools for migrating databases from other systems to Oracle Database. This includes capabilities for importing data, converting schemas, and migrating code.
  • Reporting and Exporting: Users can generate reports based on database objects, query results, or metadata. SQL Developer also provides options for exporting data in various formats, including CSV, Excel, and XML.
  • Extensions and Customization: SQL Developer supports extensions and plugins, allowing users to extend its functionality or customize the interface to suit their needs.

Moreover, with SQL Developer, you can Browse Database Objects, Run SQL Statements and SQL Scripts, and Edit and Debug PL/SQL Statements.

Especially relevant: the Only Requirement for SQL Developer Lubuntu 18.04 Bionic Installation is the Oracle Java Development Kit.

How to Install Oracle Sql Developer Lubuntu 18.04 Bionic - Featured
  1. Open a Shell Terminal emulator window
    Ctrl+Alt+t on desktop
    (Press “Enter” to Execute Commands)

    How to Install Oracle Sql Developer Lubuntu 18.04 Bionic - open terminal
  2. Download Oracle SQL Developer for GNU/Linux.

    Oracle SQL Developer .zip Linux
  3. Then Double-Click on Archive and Extract into /tmp.

    How to Install Oracle Sql Developer Lubuntu 18.04 Bionic - Extraction

  4. Next Relocate Oracle SQL Developer.

    sudo mv /tmp/sqldeveloper /opt/

    Give Execution permissions:

    sudo chmod +x /opt/sqldeveloper/sqldeveloper.sh

    Again Set the SuperUser as Owner:

    sudo chown -R root:root /opt/sqldeveloper/sqldeveloper.sh

    Make a Symlink for Easy Launching:

    sudo ln -s /opt/sqldeveloper/sqldeveloper.sh /usr/local/bin/sqldeveloper
  5. How to Install Required Oracle-Sun JDK 8+ on Lubuntu

    Oracle JDK Lubuntu Installation Guide
  6. Finally, to Launch Oracle SQL Developer
    From Terminal:

    sqldeveloper

    How to Create a Desktop Menu SQL Developer Launcher

    Making App Launcher Guide
    How to Install Oracle Sql Developer Lubuntu 18.04 Bionic - Launching
How to Install Oracle Sql Developer Lubuntu 18.04 Bionic - GUI

QuickChic Theme • Powered by WordPress