I am looking at a transactional-level table for which I need to extract all transactions which occurred between certain hours (between 15:00 and 23:59) of a day for the past year. How can I do this using Oracle SQL syntax?
What Oracle SQL syntax do I need to find transactions that occurred during time intervals of a day for a period of a year
oracleplsql
Related Question
- Problems with generating Audit SQL
- Sql-server – Does SQL Server 2008 have an equivalent to Oracle’s “table%rowtype” syntax or (Data Type)
- Sql-server – the fastest method to migrate large tables from Oracle to SQL Server
- Oracle Memory Consumption – Identify Memory Usage from a Specific Session
- Sql-server – Oracle equivalent for Linked Server and can you join with SQL Server
- Oracle – How to Make a Function Selectable Using table() Clause and Custom Data Type
Best Answer
Simply add a WHERE-condition like this:
To dynamically define the previous year: