What does SQL*Plus do?

Question

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 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.

What is the difference between SQL Plus and SQL*Plus?

SQL * Plus is a tool to use SQL language for a database from Oracle corporation. SQL can be simply used to ask queries, i.e. it involves DML, DDL and DCL. SQL * Plus is command line tool which doesn't involve DML, DDL and DCL. Whereas, in SQL * Plus there is a continuation character.

What are SQL*Plus reports?

SQL*Plus displays a report that is too long to fit on one page on several consecutive pages, each with its own titles and column headings. The amount of data SQL*Plus displays on each page depends on the current page dimensions.

Expert · Answer