What is the method for formatting the results of a SQLPlus query?

2 years ago
Noah Thompson
1 minute

In SQL*Plus, the following commands can be used to format query results:

  1. Format columns:
COLUMN column_name FORMAT format

For example, format the column named “employee_name” to a width of 50 characters.

COLUMN employee_name FORMAT A50
  1. Set the footer format.
SET PAGESIZE n

n is the number of lines displayed per page.

  1. Set the header format:
SET HEADSEP off

Disable the header separator line.

  1. Title setting:
SET TITLE title

For example, setting the title as “Employee Information”

SET TITLE 'Employee Information'
  1. Set column delimiter:
SET COLSEP separator

For example, set the column delimiter to a comma.

SET COLSEP ,
  1. View current formatting:
SHOW ALL

The above commands allow for flexible formatting of query results to meet different needs.

bannerAds