SQL*Plus uses column names as default column headings while displaying query results. You can customize your own column heading and width with the help of following commands.
To assign a new column heading, use the following command syntax:
column heading ;e.g. column ename heading EmpName; To set the width of column to four characters, use the following command:
Syntax: column format a4; Use format a5; to set the width to five characters, format a3; to set the width of the column to three characters and so on.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
