Oracle Interview Question

Display frequency of duplicate characters in a given strong.