with t as (
select 5 order_qty from dual 
)

select case when order_qty >= ( level * 2 ) then 2 else mod( order_qty,2) end
from t connect by level <= round ( order_qty / 2 ) 

WITH T AS 
(
SELECT 5 ORDER_QTY FROM DUAL 
)
 SELECT DECODE(CONNECT_BY_ISLEAF, 1, MOD(ORDER_QTY, :DIVQTY), :DIVQTY) DIVQTY 
   FROM T 
CONNECT BY LEVEL <= CEIL(ORDER_QTY / :DIVQTY)

WITH T AS (SELECT 5 ORDER_QTY FROM DUAL)
SELECT 
   CASE WHEN MOD(ORDER_QTY,2)=1 AND COUNT(*) OVER()=ROWNUM THEN 1 ELSE 2 END ORDER_QTY
FROM TEMP
CONNECT BY LEVEL<=ROUND(ORDER_QTY/2)

-- 재귀(오라클 기준)
WITH t1(order_qty) AS
(
	SELECT 5 FROM dual 
)
, t2(use_qty) AS 
(
	SELECT 2 FROM dual 
)  
, t3(order_qty, rmn_qty) AS
(
	SELECT LEAST(t1.order_qty, t2.use_qty), t1.order_qty - LEAST(t1.order_qty, t2.use_qty)
  FROM t1, t2
  UNION ALL 
  SELECT LEAST(t3.rmn_qty, t2.use_qty), t3.rmn_qty - LEAST(t3.rmn_qty, t2.use_qty)
  FROM t3, t2
  WHERE t3.rmn_qty >= t2.use_qty OR t3.rmn_qty > 0
) 

SELECT order_qty
FROM t3