Writing the statement in SQL Plus

What is SQL*Plus?

SQL*Plus is Oracle's command-line tool for interacting directly with an Oracle database—running queries, executing scripts, and formatting output.

Connecting

A typical connection looks like: sqlplus username/password@database, after which the user is dropped into an interactive SQL prompt.

Basic Statement Structure

Statements are typically terminated with a semicolon, for example: SELECT * FROM employees; To run a saved script instead of typing interactively, use @script_name.sql.

Useful Commands

Commands like DESCRIBE table_name show a table's column structure, and SET LINESIZE / SET PAGESIZE adjust how query results are displayed.