SQL> select to_char(to_date(cir_dt,'DD-MON-RRRR'),'fmDay,Month,DD,RRRR') from cir_info;
TO_CHAR(TO_DATE(CIR_DT,'DD-
---------------------------
Saturday,February,25,2017
SQL> select to_char(to_date(cir_dt,'DD-MON-RRRR'),'Day,Month,DD,RRRR') from cir_info;
TO_CHAR(TO_DATE(CIR_DT,'DD-
---------------------------
Saturday ,February ,25,2017
SQL> select to_char(to_date(cir_dt,'DD-MON-RRRR'),'fmDay,Month,DD,RRRR') from cir_info;
TO_CHAR(TO_DATE(CIR_DT,'DD-
---------------------------
Saturday,February,25,2017
SQL> select to_char(to_date(cir_dt,'DD-MON-RRRR'),'fmDay,Month DD,RRRR') from cir_info;
TO_CHAR(TO_DATE(CIR_DT,'DD-
---------------------------
Saturday,February 25,2017
Subscribe to:
Post Comments (Atom)
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ... -
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment