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.
When prompted, enter your Oracle Database username and password.
Alternatively, enter the SQL*Plus command in the form sqlplus username/password
To hide your password, enter the SQL*Plus command in the form sqlplus username
You will be prompted to enter your password.
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.
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
Connecting to Database
Click on new connection (+) Button. It will prompt for data base details.
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.
Then worksheet will open to work with database.
You can see all data base objects by expanding the connection.