title: Function in Oracle to Get time along with a Display Message :)
body: <p>Hey I tried It for a lot of time but I cannot fix this simple program to work for my personal website.I want to extract the current time and display a message with it.</p>
  
  <p>Like The current time is: 12:00 am</p>
  
  <p>Here is my code.</p>
  
  <pre><code>Create Function A1SF_GETTIME Is
  
      Temptime Char(20);   
      Message  Varchar2(20) := 'The Current Time is :';
      Begin
      Select to_char(sysdate, 'HH24:MI:SS') As "Current Time"   
      Into   TempTime   
      From dual;
      dbms_output.put_line(Message || ' ' || TempTime);      
  End;
  </code></pre>