0 votes
in Oracle by
What is SQL*plus? And what can be done with it?

1 Answer

0 votes
by

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

Related questions

0 votes
asked Jan 6, 2021 in C Plus Plus by GeorgeBell
0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...