title: Oracle Apex : Showing SQL Count beside Navigation Menu Icon and Text
body: <p>I want a dynamic number (an output of SQL query) to be shown besides page link text and icon in the navigation menu of my Oracle Apex application (Just the way it has been done in Oracle Apex Opportunity Tracker sample application).</p>
  <p>Editing the static text of link is really simple and can be done by going to *<em><strong>Application123\Shared Components\Lists*</strong></em> and editing <strong>Application Menu</strong> but what I don't know is that how can I display a count there besides the Text and icon.</p>
  <p>This is the desired output <a href="https://i.stack.imgur.com/VhepL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VhepL.png" alt="enter image description here" /></a></p>
  <p>This is where I know, I can edit the text (static) and change/select the icon for the link <a href="https://i.stack.imgur.com/HRIiS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HRIiS.png" alt="enter image description here" /></a>
  but where to write SQL query and get its result instead of [&amp;Leads.] , that's is not in my knowledge. Really appreciate help on this !!!!</p>
  <pre><code>select count(mycolumnname)
  from mytablename
  where anotherdatecolumn = trunc(current_date)  and (referid='1' or referid='12' or referidD='18');
  </code></pre>