You can COMPUTE on NUMBER columns and, in certain cases, on all types of columns. The COMPUTE command has no effect without a corresponding BREAK command. To include multiple break columns and actions in BREAK when using it in conjunction with COMPUTE, use these commands in the following forms:īREAK ON break_column_1 SKIP PAGE ON break_column_2 SKIP 1 You can include multiple break columns and actions, such as skipping lines in the BREAK command, as long as the column you name after ON in the COMPUTE command also appears after ON in the BREAK command. Use the BREAK and COMPUTE commands together in the following forms:ĬOMPUTE function LABEL label_name OF column column column You do this with the functions of the SQL*Plus COMPUTE command. If you organize the rows of a report into subsets with the BREAK command, you can perform various computations on the rows in each subset. If you format an NCLOB, BLOB, BFILE or multibyte CLOB column with COLUMN WORD_WRAPPED, the column data behaves as though COLUMN WRAPPED was applied instead.Ĭomputing Summary Lines when a Break Column's Value Changes NCLOB, BLOB, BFILE or multibyte CLOB columns cannot be formatted with the WORD_WRAPPED option. You will use the WORD_WRAPPED clause of COLUMN later in this chapter. See the COLUMN command for more information on these clauses.

The system variable WRAP controls all columns you can override the setting of WRAP for a given column through the WRAPPED, WORD_WRAPPED, and TRUNCATED clauses of the COLUMN command. If WRAP is set to OFF, the names are truncated (cut off) after the fourth character. If the WRAP variable of the SET command is set to ON (its default value), the employee names wrap to the next line after the fourth character, as shown in Example 6-5, 'Formatting a Character Column'.

Notepad++ sort by line length