Monday 7 November 2016

Convert number to characters in oracle apps sql query

/* Formatted on 11/7/2016 1:16:43 PM (QP5 v5.114.809.3010) */
SELECT   USER_ID, (TO_CHAR (TO_DATE (USER_ID, 'j'), 'Jsp')) user_id_string
  FROM   FND_USER
 WHERE   USER_NAME = '008368';

No comments:

Post a Comment