Monday, December 27, 2010

How would you display time of the day

SET SERVEROUTPUT ON
BEGIN
       DBMS_OUTPUT.PUT_LINE('Today is '|| TO_CHAR( sysdate, 'Day, HH24:MI'));
END;
/
Today is Monday   , 10:21
PL/SQL procedure successfully completed.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

External Table

Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...

  • Tips on cursor
    The number of variables must be equal to the number of column or expression in the SELECT list. The number of component in record must ...
  • Function overloading by name of parameters
    SET SERVEROUTPUT ON DECLARE      FUNCTION getArea(v_radious NUMBER, v_precision NUMBER) RETURN NUMBER IS      l_pi NUMBER := 3.14;      ...
  • Autonomous Transactions
    When an autonomous transactions is called it leaves context of calling program, perform an independent task without affecting calling prog...