SQL Plus and SQL Developer

SQL Plus

SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.

SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands to perform the following:

  • Format, perform calculations on, store, and print from query results
  • Examine table and object definitions
  • Develop and run batch scripts
  • Perform database administration

To start SQL*Plus and connect to the default database

Open a Linux or a Windows terminal and enter sqlplus command.

sqplus

sqplus2.png

When prompted, enter your Oracle Database username and password.

Alternatively, enter the SQL*Plus command in the form sqlplus username/password

Commandprompt
To hide your password, enter the SQL*Plus command in the form sqlplus username
You will be prompted to enter your password.

sqplus3.JPG

SQL*Plus starts and connects to the default database.

Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt.

SQL Developer.

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. 

If oracle database server installed in your local system, just search for SQL developer, it will install along with db server.

If oracle database installed remotely, you should install oracle client to communicate to the remote database over the internet. Here also, SQL developer will come along with Oracle client software. 

If you want to install other latest SQL Developer software, you can download from Oracle website and install in your computer.

Welcome screen of SQL Developer

SQLDeveloper.png

Connecting to Database

Click on new connection (+) Button. It will prompt for data base details.

Connection

Enter Connection Name, user name, passwd, hostname (for remote connection enter IP address) and SID and click on Test button.

Once connection is successful, click on Save button and Connect to connect the database.

Success_Connection.JPG

Then worksheet will open to work with database.

Worksheet.jpg

You can see all data base objects by expanding the connection.

objects

Advertisements

Post your Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s