Dear,
Thank you for this plugin, it's great. I have fixed the code to read the default date format form nls_paramteres insted of being hardcoded..
SELECT NVL(p_item.format_mask, upper(value)) into attr_date_format FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';
Another option will be to use v('APP_NLS_DATE_FORMAT')...
Kind regards,
Dear,
Thank you for this plugin, it's great. I have fixed the code to read the default date format form nls_paramteres insted of being hardcoded..
SELECT NVL(p_item.format_mask, upper(value)) into attr_date_format FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';Another option will be to use v('APP_NLS_DATE_FORMAT')...
Kind regards,