ORACLE - How get sessionid

Every login in Oracle has our sessionid - you can use it for example for data inserted to table:

insert into factory.an_question_fort
( sessionid, tl_nr, tl_fam, tl_atn, bst_akt_mz, dat_neu )
values
( userenv( 'SESSIONID' ), pc_m.tl_nr, pc_m.tl_fam, pc_m.tl_atn, iInv, trunc( sysdate ) );

ORACLE - How get sessionid variable

Oracle sessionid identify user session - every user has own sessionid.

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;