title: How to append parenthesis if a specific condition satisfies in Oracle
body: <p>I have below query which gives me output like <code>-$97.90</code> or <code>$11.00</code></p>
  
  <pre><code>Select TRIM(to_char(pen_amt,'$999,999,999,999,999.99')) as PenAmount
  from transact;
  </code></pre>
  
  <p>Now, if the value starts with <code>-</code>, I want to remove <code>-</code> and encapsulate the same as <code>($97.90)</code>. How can I do this?</p>