install oracle sql developer tool docker

You are currently connected as the HR user from previous step. Click Connect to connect to the database as the HR user. Click Save to save the connection information for the HR user. Provide connection properties for the HR user: You will see the execution status on the bottom portion. Highlight all the commands and click on the Run Statement button.ĭ. Copy and paste the following commands to the SQL Worksheet:ĬREATE USER hr IDENTIFIED BY welcome1 ALTER USER hr DEFAULT TABLESPACE users QUOTA UNLIMITED ON users ALTER USER hr TEMPORARY TABLESPACE temp GRANT CREATE SESSION, CREATE VIEW, ALTER SESSION, CREATE SEQUENCE TO hr GRANT CREATE SYNONYM, CREATE DATABASE LINK, RESOURCE, UNLIMITED TABLESPACE TO hr You are currently connected as the SYS user from previous step. Click Connect to connect to the database as the SYS user. Click Save to save the connection information for the SYS user. - Hostname: Host IP in OCCS (reference step 4).If you deployed the Oracle Database 12c EE from Docker Store, then you can obtain the default password and service name from the Setup Instructions of the container image in Docker Store. Provide connection properties for the SYS user: Right click on the Connections and create a New Connection.ī. Download the ZIP file from GitHub and extract the files to your local directory.

Download Oracle Database Sample Schemas from GitHub:

Connect to database as SYS user and create HR user.

Download Oracle Database Sample Schemas from GitHub.

The Oracle Database used in this tutorial is a Docker container running in Oracle Container Cloud Service. In this tutorial you will learn how to use SQL Developer to connect to a containerized Oracle Database and load the HR sample schema. Run sql query online.Using SQL Developer to Load and Query Data in Oracle Database Container

Install oracle sql developer tool docker