About Label Definitions

The basic Water application contains one predefined label definition for most feature classes. The standard attribute for the label text is called Name Number.

Note:

By default labels are not visible in the drawing. Only labels that are defined as auto labels are created during the create feature operation. Insert labels using Home tab Quick Access panel Create Label.

Example Pipe label — The following label definition is used to display a label containing the diameter, material, and length. The label text is queried from the tables WA_PIPE, WA_LINE, and WA_MATERIAL_TBD.

SELECT nvl2(max(pipe.DIAMETER_NOMINAL),'','')||max(pipe.DIAMETER_NOMINAL)||' '||round(sum(line.LENGTH),1)||' '||max(material.VALUE)
 FROM WA_PIPE         pipe,
      WA_LINE         line,
      WA_MATERIAL_TBD material
 WHERE pipe.FID               = $id
 AND   pipe.FID               = line.FID_ATTR(+)
 AND   pipe.ID_MATERIAL = material.ID(+)

For more information about defining labels, see the Creating a Label Definition.