Sunday, January 22, 2017

9 sion/tion

After Three hours calculations, I came to the conclusion that matriculation examination is nothing but botheration is Bengali nation whose occupation is cultivation during summer vacation

Test 15


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

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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...