Home arrow Oracle arrow Page 2 - How to Use the Oracle SQL Developer Tool

Connecting to databases - Oracle

Now there is a standalone graphic user interface that you can use to develop your SQL with Oracle databases. The many things you do in Oracle 10G XE can also be carried out with the Oracle SQL Developer. It is expected to enhance productivity in your Oracle applications.

TABLE OF CONTENTS:
  1. How to Use the Oracle SQL Developer Tool
  2. Connecting to databases
  3. Verifying objects in the database
  4. Creating a SQL Query
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 40
February 28, 2007

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

This tutorial shows how to connect to Oracle 10G XE. SQL Developer supports other databases for which you can find the correct syntax for connection Information.

Connecting to the Oracle 10G XE database

It will be helpful if you refresh your Oracle 10G XE knowledge or read the several Oracle 10G XE articles on the DevShed site. This is a good place for you to look at new developments, scripts, UI description, etc. The connection will be made to the Oracle 10G XE with the credentials hr, hr. Click on the "Connections" icon with the bright green plus sign as shown.

This opens up the next window, New/Select Database Connection. This is where you must supply all the information. As you can see it has identified a resident Oracle 10G XE on the machine. Of course you need to configure it further. In addition to Oracle it can connect to MySQL, MS Access, and SQL Server as well.

On the left hand side of this window you will generate the Connection Name and Connection Details once you fill in the appropriate information on the right. Connection name is what you supply; to get connected you need to have a username and password as well. If you want, you can save the password to avoid providing it again and again. At the bottom of the screen you can save the connection, test it and connect to it. There is also access to online help.

Insert the following information:

Connection Name: Test10G (or whatever)
Username: hr
Password: hr (turns to **)
Save Password is selected.
Oracle is default
Connection type: Basic

With this click on the Test button at the bottom. A testing window pops up with a progress bar. Now click on the Connect button, which establishes the connection as shown. When you click on the + node of the Connections for Test10G you can expand the node to see its content as shown. You can further expand the various nodes to see more details.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: