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

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...