Method 1:
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF'
Method 2:-
Go to Tools --> Preferences --> Database --> NLS --> Date Format --> DD-MON-RR HH:MI:SS
Thursday, 21 September 2023
Subscribe to:
Posts (Atom)
-
create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number) IS CURSOR cur_new_attmt IS select ponumbe...
-
I encountered this issue while Jdeveloper Setup. Below are the steps followed. Step 1: Run regedit (remember to run it as the administrato... -
SELECT parent_flex_value, flex_value, ROWNUM AS row_num FROM apps.fnd_flex_value_ch...