用 select 寫 九九乘法表

with a as 

 (select level x

    from dual 

  connect by level <= 9), 

b as

(select level y 

    from dual 

  connect by level <= 9)

select x,y,x*y from a,b

order by x,y ;

Oracle date

"sfb01 like '%' and sfb13 between TO_DATE('2011-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and TO_DATE('2011-01-31 00:00:00','YYYY-MM-DD HH24:MI:SS')"