How can you modify the display length of columns in sqlplus?

1 year ago

Noah Thompson

1 minute

To modify the display length of a column, you can use the SET command to adjust the properties of SQL*Plus.

Here is an example demonstrating how to set the display length of a column to 20 characters:

Open the SQL*Plus command line tool.
Enter the CONNECT command to connect to the database.
Use the SET command to set the display length of the column to 20 characters.

Adjust the line width to 20 characters.

Enter your SQL query statement and press Enter to execute.

In this way, the columns in the query results will be displayed within a limit of 20 characters width. If the content of a column exceeds 20 characters, it will be truncated.