--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Sunday, January 22, 2017
Saturday, January 21, 2017
must character
--para
where to_char(to_date(GRN_AC_DT,'dd-mon-yyyy/HH24:MI:SS'),'DD/mm/rr')= :p_adt
list--
SELECT distinct to_char(to_date(GRN_AC_DT,'dd-mon-yyyy/HH24:MI:SS'),'DD/mm/rr') X FROM GRN_EDITED order by x DESC
where to_char(to_date(GRN_AC_DT,'dd-mon-yyyy/HH24:MI:SS'),'DD/mm/rr')= :p_adt
list--
SELECT distinct to_char(to_date(GRN_AC_DT,'dd-mon-yyyy/HH24:MI:SS'),'DD/mm/rr') X FROM GRN_EDITED order by x DESC
Friday, January 20, 2017
Oracle distinct Date
SELECT distinct to_char(to_date(AC_DT,'dd-mon-yyyy/HH24:MI:SS'),'DD/mm/rr') x FROM EDITED;
X
--------
13/02/13
07/03/13
10/03/13
11/03/13
28/03/13
16/03/13
08/04/13
25/04/13
02/05/13
29/04/13
X
--------
13/02/13
07/03/13
10/03/13
11/03/13
28/03/13
16/03/13
08/04/13
25/04/13
02/05/13
29/04/13
Wednesday, January 18, 2017
Subscribe to:
Posts (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...