Hello Friends,I want to know that how to write a query to display last one hour transcation in a table?If anyone from you guys familiar with it then please help me out guys.
Thanks in Advance!
Hey do you have time stamp/date column in your table?
Yes I have time stamp / date column in my table.
You should select * from table_name as of timestamp (sysdate- interval '1'hour);
Hey go for SELECT acct_id, max(trans_date) as trans_date FROM transactions GROUP BY acct_id;
select * from tablename where trans_date>=sysdate-(1/24); will be your solution.
There is one column lost_ddl_time in 'all_objects' table.
Sign up for STechies