`select
    order_price,
    To_char(to_date(order_date,'YYYY-MM-DD HH24:MI:SS'),'yyyymmdd hh24') as order_date, 
SUM(order_price) OVER(ORDER BY To_char(to_date(order_date,'YYYY-MM-DD HH24:MI:SS'),'yyyymmdd 
hh24')) as "bth" 
from order_tbl 
where seller_no=100 
order by order_date;`

I got this result.

But the data I want to get is as follows.

20000 / 20220524 15 / 52500

13000 / 20220524 15 / 52500

19500 / 20220524 15 / 52500

19600 / 20220524 16 / 72100

222000 / 20220524 17 / 738700

and even if there is no data…

0 / 20220524 18 / 738700

0 / 20220524 19 / 738700

0 / 20220524 20 / 738700
.

.

.

.

0 / 20220525 10 / 738700

13600 / 20220525 11 / 787300

like this.

I want to get the order_date and bth for every hour even if there is no data.

It’s too difficult for me, but how can I do?

i will remove order_price and add distinct later.