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...

  • 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...
  • Cursor FOR Loop
    Cursor for loop simplifies the PL/SQL program where PL/SQL itself take care most of the things which includes cursor steps and variab...
  • Dynamic SQL - Execute Immediate & Bulk Collection
    DECLARE   TYPE emp_ref_cursor IS REF CURSOR;   TYPE empno_tab IS TABLE OF NUMBER;   TYPE ename_tab IS TABLE OF VARCHAR2(50);     v_emp_...