PL/SQL Working with 'dbms_output.put_line' statement


declare
  v_day varchar2(20);
begin
  v_day:= to_char(sysdate, 'Day');
  dbms_output.put_line('Today is '||v_day);
end;


declare
  v_day varchar2(20);
begin
  v_day:= to_char(sysdate, 'Day, HH24:MI');
  dbms_output.put_line('Today is '||v_day);
end;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document