How to add emp and dept sample table in Oracle 11g Sql developer

This post is related to older posts see How to install Oracle 11g. 
 

Step 1. Open get started with orcale from your desktop:

Browser will be opened .Let it load.

 

Step 2. Open application express

 

Step 3. Database username and passward:

Now Use SYSTEM as username
and Password : 123

Step 4.

Now create new database as following:
database username: testingdb
application express username: testingdb
passward: 123
then click on create workspace. Done. Now you can exit browser.

Step 5.

Go to sql developer. Click on symbol to Create new connection.

enter following details as in image with. password is again 123

click on connect and then type the query.Cogratulations you made it.

note: if it doesnt work restart the application or restart the computer.

Related posts: skip adds if they appear 

How to install Oracle 11g.
How to Connect Sql Wroksheet ,Sql developer with Oracle 11g

How To Install Oracle database 11g for Students part 1

 Oracle 10g or 11g is usually used by students at undergraduate level. in DATABASE you also work with Sql. Sql + worksheet or Sql Developer. Here are complete steps to setup you Oracle 11g.

Step 1.

Download and select the highlighted options

skip advertise if it appears 

Download > ORACLE DATABASE EXPRESS EDITION 11G release 2.

 

 

Step 2.

Skip this step if you have JDK 7. 

Note: JDK 8 is note working with Sql developer at the time of writing this post. So if you are facing any problem unistall JDK 8 and instal jdk7 .

skip advertise if it appears

Download > JDK 7

Step 3.

Download > SQL Developer

 Step 4.

Now install the above mentioned Downloads in following order
a. install JDK in default location
b. install oracle 11g (give 123 passward if it asks)
c. install sql developer (extract and open sqldevelpoer.exe in sql developer folder)

Continued...

GO > How to install oracle 11g  PART 2