Zero suppression

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

Zero Suppression is a technique used to replace leading zeroes with spaces in numeric data for display purposes.

Examples:

  • 00000123 will be displayed as 123
  • 1.230000 will be displayed as 1.23
  • 0012.300 will be displayed as 12.3
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #


Retrieved from "http://www.orafaq.com/wiki/index.php?title=Zero_suppression&oldid=7413"