The computed values print on a separate line when the value of the ordered column changes. The function you specify in the COMPUTE command applies to all columns you enter after OF and before ON. Standard deviation of the values in the column. The following table lists compute functions and their effects For more information see the COMPUTE command. 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 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 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".
0 kommentar(er)
