select a.id,a.no,a.name from table
as of timestamp to_timestamp('2017-03-29 15:21:41','YYYY-MM-DD HH24:MI:SS') a
where a.billrno ='B170329000100'
as of timestamp to_timestamp('2017-03-29 15:21:41','YYYY-MM-DD HH24:MI:SS') a
where a.billrno ='B170329000100'