Question

What is SQL*plus? And what can be done with it?

Answer 1

SQL* Plus is a component of Oracle Database. It is basically a command-line tool that allows you to submit SQL queries to the server interactively.

1. We can view the results by Running a SELECT query
2. With SQL*Plus we can startup and shutdown a Oracle database.
3. Submit PL/SQL blocks for execution to the Oracle server.
4. Execution of SQL*Plus script file can be done.
5. Create, modify, or drop database objects(eg., tables, indexes, and users) using DDL statements, as well as any other SQL statements that Oracle supports.
6. We can write the output to a file.
7. Execute stored procedures and functions in a database