SLTechnology News&Howtos › Database ›

Oracle business optimization ask for help, ask for repetition of this month and last month in the combined partition table

Shulou Source: shulou.com Published: 2022-06-01 14:12:13 10月03日 Update

With cur_month as

(select *

From CUST_SFM_JYCRMEPC_LIST

Where mold = '302'

And create_time > =

To_date (to_char (sysdate, 'yyyy/mm') | |' / 01, 'yyyy-mm-dd')

And create_time =

To_date (to_char (ADD_MONTHS (sysdate,-1), 'yyyy/mm') |' / 01'

'yyyy-mm-dd')

And create_time