Blogger
Published in

Blogger

Setup Environment For Oracle Database.

i) Visit the Oracle Database Express Edition (XE) site.

ii) Download the package which is given for windows.

iii) unzip the downloaded package and run the setup.exe

iv) Always make sure to use

Username : SYSTEMPassword : oracle

v) Visit the Oracle SQL Developer site and download the developer package

vi) Download the package which is for windows.

vii) Unzip the package and open the sqldeveloper.exe

viii) Add these credentials

Connection Name : test db (any name you preffered)Username : SYSTEMPassword : oracle

Note : Click test button and check the status . if the status is Success you are good to connect and continue work

ix) Execute the below queries and check the results in database.

CREATE TABLE Persons (PersonID int,LastName varchar(255), FirstName varchar(255),Address varchar(255),City varchar(255));insert into persons VALUES (1,’Naveen’,’Fernando’,’Boralesgamuwa’,’Colombo’);SELECT * FROM Persons;

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Naveen Fernando

Naveen Fernando

25 years old | Software Engineer | Currently live in Sri-Lanka | Interested In Kafka, Web Scraping, Data Science, Concurrency programming, Java, Angular.