title: Altering return value of Varchar2 form default(4000) to (10char)?
body: <p>My Question is:</p>
  
  <pre><code>create function jbmdate (p_date in varchar2)
  return varchar2
  as
  begin
    return to_char(to_date(p_date,'YYYYMMDD'),'DD.MM.YYYY');
  end;
  </code></pre>
  
  <p>As you see this returns a varchar with default value : 4000 byte/char.</p>
  
  <p>But the Problem is that it will be used within a GUI so 4000 is quit unlucky big.</p>
  
  <p>So how could i possible change the return value of this varchar2 to (10 char)? </p>
  
  <p><img src="https://i.stack.imgur.com/PX7MY.png" alt="View of Gui Table altered"></p>
  
  <p>It should look like this</p>
  
  <p>but i looks like this when used in the gui.</p>
  
  <p><img src="https://i.stack.imgur.com/yjttk.png" alt="View of Gui Table"></p>
  
  <p>So the real problem is not the gui itself but the sql ... shown here in squirrle sql: 
  <img src="https://i.stack.imgur.com/9E0lw.png" alt="View of SQuirrle Table"></p>
  
  <p>So how can i alter the Precision which is returned by the function. </p>