Customizing Column Name and Width

Customizing Column Name and Width

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.


Share the Post: