procedure delete_piece
is
sID number;
begin
sID := UserEnv( 'SESSIONID' );
delete from piece
where
sessionid = sID or
to_char( dat_net, 'YYYYMMDD' ) <> to_char( sysdate, 'YYYYMMDD' );
commit;
end;
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Thursday, December 21, 2017
ORACLE - How get sessionid variable
Oracle sessionid identify user session - every user has own sessionid.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment