Difference between revisions of "SQL Developer"

Latest revision as of 17:32, 15 August 2022

Description

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

Environment Modules

Run module spider sqldeveloper to find out what environment modules are available for this application.

System Variables

HPC_SQLDEVELOPER_DIR - installation directory

Additional Information

After loading the module on one of the gui nodes run 'SQLDeveloper' or 'sqldeveloper.sh' to start the software.

@@ Line 1: / Line 1: @@
-[[Category:Software]][[Category:Programming]][[Category:Oracle]][[Category:Sql]]
+[[Category:Software]][[Category:Programming]][[Category:Database]]
 {|<!--CONFIGURATION: REQUIRED-->
 |{{#vardefine:app|sqldeveloper}}
@@ Line 5: / Line 5: @@
 <!--CONFIGURATION: OPTIONAL (|1}} means it's ON)-->
 |{{#vardefine:conf|}}           <!--CONFIGURATION-->
-|{{#vardefine:exe|}}            <!--ADDITIONAL INFO-->
+|{{#vardefine:exe|1}}            <!--ADDITIONAL INFO-->
 |{{#vardefine:pbs|}}            <!--PBS SCRIPTS-->
 |{{#vardefine:policy|}}         <!--POLICY-->
@@ Line 21: / Line 21: @@
 <!--Modules-->
-==Required Modules==
+==Environment Modules==
+Run <code>module spider {{#var:app}}</code> to find out what environment modules are available for this application.
-===Serial===
-* {{#var:app}}
-<!--
-===Parallel (OpenMP)===
-* intel
-* {{#var:app}}
-===Parallel (MPI)===
-* intel
-* openmpi
-* {{#var:app}}
--->
 ==System Variables==
-* HPC_{{#uppercase:{{#var:app}}}}_DIR - installation directory
+* HPC_{{uc:{{#var:app}}}}_DIR - installation directory
 <!--Configuration-->
 {{#if: {{#var: conf}}|==Configuration==
@@ Line 43: / Line 32: @@
 {{#if: {{#var: exe}}|==Additional Information==
-WRITE_ADDITIONAL_INSTRUCTIONS_ON_RUNNING_THE_SOFTWARE_IF_NECESSARY
+After loading the module on one of the [[GUI_Programs|gui nodes]] run '<code>SQLDeveloper</code>' or '<code>sqldeveloper.sh</code>' to start the software.
 |}}