Thursday, July 7, 2011

fnd_sessions script

insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(USERENV('SESSIONID'), trunc(SYSDATE));
Posted by at

1 comment:

  1. AnonymousDecember 15, 2018 at 8:37 PM

    Hello,

    Why at last we have to do? If we do insert in table, will Oracle automatically purge it ?
    INSERT INTO FND_SESSIONS VALUES
    (USERENV('sessionid'),TRUNC(sysdate)
    );

    ReplyDelete

Subscribe to: Post Comments (Atom)