SoC Database Server

Here are the details for connecting to the Oracle Database Server in the School of Computer Science.

Download and Setup SQL Developer

SQL Developer is the client software you need to use to access the database and run your SQL code. This is a free tool and needs to be downloaded and unzipped on your laptop/desktop. There is no install. Just unzip and it is ready to use.

SQL Developer is installed on all lab PCs, so you can skip this step. But if you want to install SQL Developer on your own laptop then you will need to complete the following.

To download SQL Developer go to the Download Page.

Select the Download file that includes JDK.  This download does not require any additional JDK setup or configuration

After downloading the file, unzip it.

Then go to the unzipped folder and run the ‘sqldeveloper.exe’ file

More details about the tool can be found on the SQL Developer webpage.

Creating a Connection using SQL Developer

After starting SQL Developer, you will need to create a connection to the database.

Click on the green plus icon on the top left of the tool

A Connections window will open.

Enter your Database Connection details:

  1. Enter a Name for your connection. You can call it whatever you want as this field is free-format
  2. Enter your Oracle Schema Username and Password  (ask your lecturer for this). The username and password are case sensitive.
  3. Change your Connection Type to ‘Cloud Wallet‘ from the drop-down list
  4. Select the zip file containing the Cloud Wallet.
      1. Group A – Download this zip file from here.
      2. Group B – Download this zip file.
  5. Set the Service from the drop down list.
      1. The Wallet should have just one Service.  Select it.
      2. The Service will have different names depending on which one you download (Group A or Group B)

Click on the Test button to see if you have entered the details correctly.  If you get an error, then you have not entered the details correctly.

Click the Save button to save the connection details.

Finally, click the Connect button to make the database connection and open a SQL Worksheet

Check out links to SQL and PL/SQL tutorials.

Students will be assigned a schema/user name and password by their lecturer. This will be given to the student in class.

Change your Password

You need to have an open connection to the database. Open a SQL Worksheet and type the following command

alter user <username> identified by <new_password>;

or

right-click on your connection name, and select Reset Password from the menu

Demo Code

Try creating a table and insert some data. You should be able to do this. You should not get any errors. If you do, make sure you don’t have any typos or mistakes. After checking this and you are still getting errors discuss them with your lecturer, making sure you provide the full error message (error code and message) and the code you are trying to run.

create table t_demo (
t_id number primary key,
t_name varchar2(20) not null,
t_address varchar2(50),
t_DOB Date );

insert into t_demo (t_id, t_name, t_address, t_DOB)
values (1, 'Student Name', 'Dublin', to_date('01/02/2020', 'DD/MM/YYYY'));

select * from t_demo;