对于选择查询，您可以尝试以下操作:

For select query, you can try this:

Select   H.dept_id , SEQ ,time_stamp , dept _name
From History H inner join Departments D on D.dept_id  = H.dept_id
Where   seq = v_input_seq