Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Using Format Masks mixed with user string

SQL> SQL> declare   2      v_dt DATE :=sysdate;   3      v_tx VARCHAR2(2000);   4  begin   5      v_tx:=to_char(v_dt,'"Today is": DAY');   6      DBMS_OUTPUT.put_line(v_tx);   7  end;   8  / Today is: SATURDAY PL/SQL procedure successfully completed.