How To Connect Oracle 11g Express Edition to Eclipse

Hello everybody!

Let's see how to connect Oracle 11g Express Edition that we just installed (here is the guide for installaton) to Eclipse.

STEP 1

Download the compatible ojdbc.jar from this link. Put it somewhere on your computer. I placed mine under "C:\ojdbc" folder.

How to Install Oracle 11g Express Edition on Windows

Hello everybody!

You can find a quick step by step guide about installing Oracle 11g Express Edition on Windows here. I hope it is useful for you!

STEP 1

Go to this link to download Oracle 11g Express Edition. First accept the licence agreement and then click on whichever version is compatible with your operating system. I will go with Windows x64.

Oracle Database 11g How To Set "Auto Increment"

Hello everbody!

Setting auto increment property in Oracle 11g is a little bit different from way that I am used to with other databases. There is no such keyword as auto_increment in Oracle 11g. We have to achieve it by using the codes below.

Oracle 11g - A Solution To The Password Will Expire Error - ORA-28002

Hello everbody!

Today I have seen an error which tells me my Oracle 11g database user's password will expire in a day! So I had to sort this out before I did any work with the database. I also decided to write a blog post about the solution. Here we go.. This is the error message I got and here is the solution.

Oracle Database 11g - Creating A New User

Hello everybody!

Creating a new user in Oracle 11g is not too complicated. You just follow these steps below. Before that if you want to have a look at installing Oracle 11g Express Edition on Window just click here.

STEP1 - Connect as a SYSTEM USER

Open SQL command line and type this:
connect / as sysdba