Excuse me for asking very stupid SQL question. Say I have a transaction table called trans_test having one of columns as mod_date ( this is defined as datetime type). I need to list all records inserted into this table during past half hour.
Oracle in my home computer is hosed up and therefore not able to test the SQL myself. So guys please try to help me.