Shulou(Shulou.com)06/01 Report--

The following introduces you to all the months of the oracle query up to the current date and month through a query statement. The specific code is as follows:

SELECT to_number (TO_CHAR (add_months (trunc (sysdate, 'yy'), ROWNUM-1),' MM')) as month FROM DUALCONNECT BY ROWNUM

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.