• Non ci sono risultati.

Tutorial for installing Oracle Database 18c Express Edition and SQL Developer (Windows)

N/A
N/A
Protected

Academic year: 2021

Condividi "Tutorial for installing Oracle Database 18c Express Edition and SQL Developer (Windows)"

Copied!
4
0
0

Testo completo

(1)

Tutorial for installing Oracle Database 18c Express Edition and SQL Developer (Windows)

This guide explains how to install the Oracle DBMS, where the databases we want to query will be stored, and Oracle Sql Developer, a free graphical tool/environment to run queries and SQL scripts to a database stored in an Oracle DBMS.

ORACLE DATABASE 18c EXPRESS EDITION INSTALLATION

To download the software go to the link:

https://www.oracle.com/database/technologies/xe-downloads.html

Accept the conditions and download the Windows x64 version. You are prompted to create an Oracle account in order to proceed with the download.

(2)

Screenshot of the Oracle account creation page.

(3)

Download and extract the zip file, run the setup file to install the software. During installation you will be asked to enter the password that will be used to log in as administrator (SYS or SYSTEM user).

(4)

ORACLE SQL DEVELOPER INSTALLATION

To download the software go to the link:

https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html

Download the 64-bt Windows version with JDK 8. Extract the downloaded zip file.

To open Oracle SQL Developer simply run the file sqldeveloper.exe:

Riferimenti

Documenti correlati

9 9999 Returns value with the specified number of digits with a leading space if positive or with a leading minus if negative. Leading zeros are blank, except for a zero value,

Note: If your site does not have the Automatic Workload Repository and Automatic Database Diagnostic Monitor features, then Statspack can be used to gather Oracle instance

In addition to a relational database, a data warehouse environment can include an extraction, transportation, transformation, and loading (ETL) solution, online analytical

Selezionare in SQL i cognomi dei docenti che hanno tenuto dei corsi in cui sono stati sostenuti esami da almeno 10 studenti... Esercizio

If the output of the command does not show the program version (but instead you get an error message, such as -bash: docker: command not found ), docker has not been set up

Separately for phone rate and month, analyze the (i) total income, (ii) the percentage of income with respect to the total revenue considering all the phone rates, (iii)

Torniamo ora a Sql Developer per effettuare la connessione a Oracle usando il nuovo account prova appena creato su Oracle e poter così accedere al Workspace “prova” su cui

Questa verifica non può essere effettuata eseguendo direttamente un conteggio delle tuple in IMP, in quanto in un trigger a granularità di tupla non è possibile accedere