• Arun Kumar

SQL query between dates

To query a date column between specific dates, use below query

select count(*) from DW.TB_PCDWH0091_FCT_PROJ_DTL
 where dw_load_dt between to_date('2016-09-01', 'YYYY-MM-DD HH24:MI:SS') and
 to_date('2016-10-31', 'YYYY-MM-DD HH24:MI:SS');


Recent Posts

See All

Temp Tablespace utilization

It is very common that as a DBA you will encounter ‘ORA-1652: unable to extend temp segment’. Handling temporary tablespace is different than permanent tablespaces inside Oracle. On a high level, temp

Estimate flashback destination size

Sometimes application team will ask DBA to enable flashback for x number of days. In such case, a DBA needs to estimate the flashback space required for x number of days in order to store the flashbac

Datafile utilization check

When you want to shrink a datafile, you must always check the single datafile utilization. In case if you shrink datafile more than the used size, it will fail. Below query gives the datafile utilizat