What is SQL*Plus and why would you want to use it?

Question

SQL*Plus is an Oracle-developed tool that allows you to interactively enter and execute SQL commands and PL/SQL blocks. Because these three products all have “SQL” as part of their names, people occasionally get confused about the relationship between them and about which commands get executed where.

What does SQL*Plus do?

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.

What are the advantages of SQL*Plus?

SQL*Plus enables you to manipulate SQL commands and PL/SQL blocks, and to perform many additional tasks as well. Through SQL*Plus, you can: enter, edit, store, retrieve, and run SQL commands and PL/SQL blocks. format, perform calculations on, store, and print query results in the form of reports.

What is the difference between SQL and SQL Star Plus?

SQL is the query language used for communication with Oracle server to access and modify the data. SQL* Plus is a command line tool with which you can send SQL queries to the server. Also, it can help you format the query result. SQL is a language which is invented by IBM.

What is SQL*Plus script?

In SQL*Plus command-line, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts. You can write scripts which contain SQL*Plus, SQL and PL/SQL commands, which you can retrieve and edit.

Expert · Answer