![wrap text sql server shortcut with sql prompt wrap text sql server shortcut with sql prompt](https://www.red-gate.com/wp-content/uploads/2020/10/word-image-22.png)
Now rerun the query with the slash (/) command: SQL> COLUMN ENAME HEADING 'Employee|Name' To give the column ENAME the heading EMPLOYEE NAME and to split the new heading onto two lines, enter
![wrap text sql server shortcut with sql prompt wrap text sql server shortcut with sql prompt](https://www.tech-recipes.com/wp-content/uploads/2015/08/Refresh_IntelliSense.gif)
See the SET command in Chapter 8 for more information.) (You can use a character other than a vertical bar by changing the setting of the HEADSEP variable of the SET command. To display a column heading on more than one line, use a vertical bar (|) where you want to begin a new line. To change a column heading to two or more words, enclose the new heading in single or double quotation marks when you enter the COLUMN command. The new headings will remain in effect until you enter different headings, reset each column's format, or exit from SQL*Plus. To produce a report from EMP with new headings specified for DEPTNO, ENAME, and SAL, enter the following commands: See the COLUMN command in Chapter 8 for more details. You can define a more useful column heading with the HEADING clause of the COLUMN command, in the format shown below:ĬOLUMN column_name HEADING column_heading Column names are often short and cryptic, however, and expressions can be hard to understand. SQL*Plus uses column or expression names as default column headings when displaying query results. The sections below describe how the default headings are derived and how you can alter them with the COLUMN command. When displaying column headings, you can either use the default heading or you can change it using the COLUMN command. Through the SQL*Plus COLUMN command, you can change the column headings and reformat the column data in your query results.